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

Dedicated Administrator Console (DAC) - saved an important day for a DBA

Published 4 August 7 9:9 AM | SSQA.net

Until recently I have just used Dedicated Administrator Console (DAC) to connect just to test whether the connection will be successful. You may be aware that only administrator will be able to access a running instance of SQL Server Database Engine to...

Filed under: sql server, performance, management, analysis, blocking, dba, dac, sac, investigation