Created few issues on http://pal.codeplex.com for the new functionality added in version 2.2. Where you can enter in SQL Server Instance name in a dialog
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect - Engineering
Creating a Simple Counter List in PAL (Performance Analysis of Logs)
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?
SQL Canada (SQLCAN) 