In my previous post, I talked about how implement the counters in Windows 2003. However I went about getting the list of counters from PAL
Getting List of Top Queries by Query Hash
Starting SQL 2008, we have had Query Hash column in sys.dm_exec_query_stats. It helps group common queries together, because when SQL Server is generating execution plan
Getting List of All Files and Their Growth Information
SQL Server defaults to growing data files by 1MB and transaction logs by 10%; neither of those are best practice. If your database is small
Getting Database Data/Log File Growth from Default Trace
How to calculate database growth rate using default trace?
How to implement PAL (Performance Analyis of Log) counters in Windows 2003?
How to implement PAL counters in Windows 2003?
How to find out what is causing page splits?
Client was noticing high number of Page Splits/sec in relation to Batch Request/sec; however could not figure out why. They were not have performance issue but
SQL Canada (SQLCAN) 