Rob's SQL Blog

SQL Server Waits, Locks and Blocking

robcarrol — Sat, 17 May 2008 07:30:00 GMT

The master.dbo.sysprocesses table in Microsoft SQL Server 2000 and SQL Server 2005 is a system table that contains information about the active server process IDs (SPIDs) that are running on SQL Server.

If you are using SQL Server 2005, you can also access this table by using the sys.sysprocesses compatibility view.

The waittype column, the lastwaittype column, the waittime column, and the waitresource column in the master.dbo.sysprocesses system table provide information about the resources that the processes are waiting on.

References:

How to monitor blocking in SQL Server 2005 and in SQL Server 2000
Blocked Process Report Event Class
Description of the waittype and lastwaittype columns in the master.dbo.sysprocesses table in SQL Server 2000 and SQL Server 2005

Cross Posted from blogs.technet.com/rob

SQL Server and Windows Memory

robcarrol — Thu, 15 May 2008 14:02:00 GMT

SQL Server 2000 Enterprise Edition introduced support for the use of Windows 2000 Address Windowing Extensions (AWE) to address 8GB of memory on Windows 2000 Advanced Server and 32GB of memory on Windows 2000 Datacentre. With AWE, SQL Server can reserve memory not in use by other applications and the OS. Each instance must statically allocate the memory it needs. AWE memory can only be used for the data cache and not for executables, drivers, DLL's, etc.

Cross Posted from blogs.technet.com/rob

Windows Memory (PAE/AWE/3GB)

robcarrol — Thu, 15 May 2008 12:20:00 GMT

SQL Server 2000 Enterrise Edition introduced support for the use of Windows

Cross Posted from blogs.technet.com/rob

Oracle Unbreakable... Not a Chance !

robcarrol — Thu, 17 Apr 2008 09:33:00 GMT

Good article here comparing the Critical Updates fixes between SQL Server and Oracle and some of the mis-information peddled in the RDBMS world. Highlights include zero SQL Server critical update vulnerabilities since September 2004, which I think is...(read more)

SQL Server 2000 Full-Text Issues After Failover

robcarrol — Wed, 12 Mar 2008 18:00:00 GMT

I can't take credit for finding the solution to this as that goes to my colleague, but I thought I'd share a problem we experienced after failing over one of our production clusters last night. This is a SQL Server 2000 SP4 Enterprise Edition active/passive...(read more)

SQL2K8 Launch Thoughts

robcarrol — Fri, 29 Feb 2008 19:41:00 GMT

Been reading Dan Jones blog post regarding the delay to the launch of SQL Server 2008, and I think he makes some great points. There is obviously dissapointment from some people about the release date slipping back, but as Dan points out, a bad product...(read more)

Windows Server 2008 Clustering

robcarrol — Fri, 29 Feb 2008 18:10:00 GMT

I've been having a look at Windows Server 2008 clustering and the first thing I can say is... wow ! Setting up clusters, adding additional nodes and setting up clustered resources is far simpler than before, and the cluster validation tool means there...(read more)

SQL Server 2005 Bug Report

robcarrol — Thu, 21 Feb 2008 19:43:00 GMT

Saw this link to a SQL Server 2005 bug report on the Microsoft Connect site. I guess someone was having one of those days https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=253524&wa=wsignin1.0...(read more)

SQL Server 2008 Certifications

robcarrol — Tue, 19 Feb 2008 23:50:00 GMT

As I am currently preparing for the MCDBA to MCITP 2005 upgrade exam (70-447) it may seem a bit premature to talk about SQL Server 2008 certifications, but there is a webcast available at Trika's blog (from the Microsoft Learning team) below. http://blogs...(read more)

Indexing Strategies

robcarrol — Sat, 16 Feb 2008 00:39:00 GMT

I attended the Scottish SQL Server User Group meeting during the week and heard a presentation from Martin Bell on his favourite DMV's. Mentioned in the discussion was sys.dm_db_index_usage_stats and that got me thinking about indexing strategies. I have...(read more)

PFE Technical Rollups

robcarrol — Fri, 15 Feb 2008 00:28:00 GMT

The latest Technical rollup mails from Premier Field Engineering are available here ....(read more)

Top Tips for SQL Server Clustering

robcarrol — Wed, 13 Feb 2008 17:10:00 GMT

As part of a current project I am working on, I came across this article , which includes a tip for clustering SQL Server workgroup edition using a combination of Windows clustering and virtual server !...(read more)

SQL 2008 Resource Governor

robcarrol — Tue, 12 Feb 2008 09:29:00 GMT

I came across this post in Andrew Fryer's blog, which has a short demo of the SQL Server 2008 resource governor in action. For me, this will be one of the main drivers for moving to SQL Server 2008. Most of the issues I come across with unresponsive SQL...(read more)

Free SQL Server 2008 E-Learning Available

robcarrol — Mon, 11 Feb 2008 15:32:00 GMT

There are some free e-learning tools available for SQL Server 2008 on the Microsoft E-learning site below: http://www.microsoft.com/learning/sql/2008/default.mspx There's also some free e-learning resourses for Windows Server 2008 here: http://www.microsoft...(read more)

Update: Two-thirds of Oracle DBAs don't apply security patches

robcarrol — Fri, 08 Feb 2008 09:50:00 GMT

This scary article reminded me of a conversation I had with a colleague in the middle of a team meeting recently. This centred around the perceived lack of security of SQL Server compared to Oracle and the Slammer worm was cited as an example. The damage...(read more)