Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Memory view on the Resources tab allows you to track the Total Memory usage along with other key memory statistics on the computer hosting your SQL Server instance.

Reduce OS memory usage

A high percentage of Total Memory Usage indicates a memory bottleneck. To investigate this issue, open the Memory view on the Resources tab to view how memory is utilized on your SQL Server instance. You may need to allocate more memory to SQL Server to increase your SQL Server performance, or limit the usage of other applications on the computer hosting your SQL Server instance.

Tip

To enable alerting when this metric is outside its established baseline, click the Baseline Thresholds Enabled (as percentage of baseline) check box in the Alert Configuration window.



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
| 

...

SQL  Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >

...

Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...