SQL Server profiler trace parsing tool – Build performance reports based on profiler traces only

Imagine the scenario that you application has just been deployed into production environment and SQL Server is extremely slow consuming too many resources. Sometimes a single store procedure can be easily identified by looking into DMV’s or just profiler trace. But how you can summarize entire profiler trace in simple reports that aggregate all store…

2

SQL Server 2008 – Performance counters registry hive consistency fails on non English Operating Systems

Trying to install SQL Server 2008 on a non English OS and setup is being blocked by this rule, however looking to performance counters everything looks fine. On Operating Systems pt-PT (Portuguese) setups is trying to look for HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\016 which don’t exist, setup should be looking for HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\0816 (0816 is LCID code for…

15

SQL Server 2008 installation aborts due an access denied

Trying to install SQL Server 2008 on a standalone environment using an administrator account and getting an access denied? The problem could happen in case you have removed Local Administrator from ‘Debug privileges’ on local security policies or just because your local domain GPO removes it. SQL Server installation log: (…) The Detail.txt indicates 3…

3