Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to read output from DBCC MEMORYSTATUS Sql Server

Posted on 2014-04-24
1
Medium Priority
?
3,345 Views
Last Modified: 2014-06-20
How do I read output from DBCC MEMORYSTATUS ?

Thanks,
0
Comment
Question by:FDC2005
1 Comment
 
LVL 22

Accepted Solution

by:
plusone3055 earned 1500 total points
ID: 40021154
I would like you to visit the following link.

How to use the DBCC MEMORYSTATUS command to monitor memory usage
http://support.microsoft.com/kb/907877

this contians complete details and and a more in dept defintion  DBCC MEMORYSTATUS
and other queries that can be run to provide more information. I think you will find it very beneficail. If this is not what you are looking for please elaborate and I will try to assist :)
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question