Browse by Tags

SQL Server 2008 - Activity Monitor a new key to DBA!

Published 11 March 8 3:14 AM | SSQA.net

Have you looked at the Activity Monitor screen within the Managment Studio? I feel this is somewhat surprise features included from February CTP (or was it there before?). This is more useful to the DBAs to have a look at resource activity and locking...

Filed under: sql server, blocking, dba, version, features, 2008, pages, locks, activity monitor

FIX: You cannot obtain statements in the current batch in SQL Server 2005 by using the DBCC INPUTBUFFER statement, trace flag 1204, deadlock graph event class, or Activity Monitor

Published 12 September 7 12:27 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: You cannot obtain statements in the current batch in SQL Server 2005 by...

Filed under: sql server, kba, 2008, deadlock, trace flag, 1204, dbcc inputbuffer, activity monitor