As a Proactive DBA, you must monitor All SQL Server errors having severity level between 17 to 25. Any errors from level 20 to 25 are serious in nature however for 17 to 19 a DBA involvement is required for resolution. Here is self explanatory MS description of error levels, steps to get automatic alert [...]
Posts Tagged ‘checkdb’
List of Undocumented DBCC command..
Posted: 10th March 2010 by Deepak in Scripts, SQL DBA, SQL Dev, UncategorizedTags: buffer, cachestats, checkalloc, checkdb, DBA, dbcc, dbcc page, shrinkfile, sql, sqldba, sqlperf, update, useplan
List of Undocumented DBCC command.. DBCC activecursors [(spid)] DBCC addextendedproc (function_name, dll_name) DBCC addinstance (objectname, instancename) DBCC adduserobject (name) DBCC auditevent (eventclass, eventsubclass, success, loginname, rolename, dbusername, loginid) DBCC autopilot (typeid, dbid, tabid, indid, pages [,flag]) DBCC balancefactor (variance_percent) DBCC bufcount [(number_of_buffers)] DBCC buffer ( {‘dbname’ | dbid} [, objid [, number [, printopt={0|1|2} ][, [...]
