I write about SQL Server…and occasionally something else.
-
Tidy Blog, lazyness and SQLBITS X
I said I would get round to moving some of the old content, and true to my word albeit several months later I have added the profiler/deadlocks posts. I know I should add new content, rather than repost older bits…
-
Capturing Deadlocks
So, deadlocks. “A deadlock occurs when two or more tasks permanently block each other by each task having a lock on a resource which the other tasks are trying to lock.” http://msdn.microsoft.com/en-us/library/ms178104.aspx How to capture deadlocks? How many ways can…
-
SQL Server Profiler Trace
A Trace can easily be used to monitor what is happening within SQL Server, just start SQL Server Profiler via the Tools Menu in SSMS or via a shortcut. Once started it is a relatively easy process: 1. Connect to…
-
Delta and Cumulative IO Stats
Checking IO statistics has always been one of the most important metrics for any DBA. It is no surprise that most people I know will have some version of the following two scripts that use the dmv sys.dm_io_virtual_file_stats (Transact-SQL). The dmv…
-
SQL Server Memory: Max Server Memory or Task Manager is wrong
Issue 1: max server memory <> max server memory Okay so you have run sp_configure and checked SQL and it has stolen more memory than you told it to. Aghh! sp_configure ‘show advanced options’, 1; GO RECONFIGURE; GO sp_configure ‘max…
-
Studying for the SQL MCM 2008 (Microsoft Certified Master)
This post will list the resources that I have found and that will hopefully give enough material in order to tackle the SQL MCM 2008. It will also provide an update every now and then with my progress. Anyone in…
-
List Installed Software aka Get-InstalledSoftware
I needed a script to check for installed software on local and remote machines that did not rely on the Win32_Product WMI class as this will only return software that the windows installer knows about. One way to do this…
Join 900+ subscribers
Stay in the loop with everything you need to know.