I’ll be speaking at the Inland Empire .Net User Group
The nice folks at the Inland Empire .NET User Group have invited me to come and speak to them. Read on to see the topics.
Checking the cached execution plans
We are going to take a look into sys.dm_exec_cached_plans, sys.dm_exec_requests, sys.dm_exec_query_plan, and sys.dm_exec_plan_attributes.
Checking free disk space from T/SQL
I’ve seen some very creative ways to see how much free disk space SQL Servers have. Most make use of xp_cmdshell which some very complex dos commands or vbscripts. Here is a much, much simpler one.
My ERRORLOG shows some spids have an ‘s’ after them. What’s going on?
Starting in SQL Server 2005 system processes no longer need to run with SPIDs less than 50. Because of this, Microsoft has decided to make live easier when trying to identify the system processes above 50 by putting the s after the SPID number in the logs.