Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zaty2405
Yak Posting Veteran
58 Posts |
 Posted - 2010-06-23 : 02:17:15
|
| Hi,I am having some performance issue with my database.I want to know what exatly to look for in the dbcc memorystatus output.Here is some of output after sql services restarted and another one is the output after 12 hours services get restarted.Procedure Cache Value------------------------------ -----------TotalProcs 141TotalPages 1956InUsePages 3Procedure Cache Value------------------------------ -----------TotalProcs 4524TotalPages 59439InUsePages 104Optimization Queue Value------------------------------ --------------------Overall Memory 24704925696Target Memory 23485046784Last Notification 1Timeout 6Early Termination Factor 5Optimization Queue Value------------------------------ --------------------Overall Memory 24199741440Target Memory 22489710592Last Notification 1Timeout 6Early Termination Factor 5Thanks |
|
|
|
|
|
DBCC Memorystatus