Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Troubleshooting SQL Server with the Sysperfinfo Table Expand / Collapse
Author
Message
Posted Saturday, May 10, 2003 12:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 11, 2011 5:16 AM
Points: 24, Visits: 51
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/jsack/troubleshootingsqlserverwiththesysperfinfotable.asp


Post #12090
Posted Friday, April 21, 2006 1:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:32 AM
Points: 7,010, Visits: 8,460

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


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- 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
Post #274377
Posted Friday, April 21, 2006 3:51 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 11, 2011 5:16 AM
Points: 24, Visits: 51

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.




Post #274646
Posted Monday, April 24, 2006 12:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:32 AM
Points: 7,010, Visits: 8,460

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


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- 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
Post #274746
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse