Troubleshooting SQL Server with the Sysperfinfo Table
-
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/jsack/troubleshootingsqlserverwiththesysperfinfotable.asp
-
FYI
in SQL2005 you have DMV's (e.g. sys.dm_os_memory_clerks) to followup this kind of info.
e.g. clr-info : http://blogs.msdn.com/sqlclr/archive/2006/03/24/560154.aspx
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I wrote this article a couple of years ago (back in 2003) - so I was wondering why I was getting emails on this all of the sudden!
Anyhow - SQL Server 2005 DMV and DMFs are definitely the way to go moving forward.
-
It was the featured article in the daily newsletter of 2006/04/21.
That's why I tought I just might add a path towards sql2005
Anyway, nice article
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply