May 2008 - Posts

• SQL Server Waits, Locks and Blocking

  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 Posted May 17 2008, 08:30 AM by robcarrol with no comments

• SQL Server and Windows Memory

  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 Posted May 15 2008, 03:02 PM by robcarrol with 2 comment(s) Filed under: SQL Server, Windows, Memory

• Windows Memory (PAE/AWE/3GB)

  SQL Server 2000 Enterrise Edition introduced support for the use of Windows   Cross Posted from blogs.technet.com/rob Posted May 15 2008, 01:20 PM by robcarrol with no comments