Following are couple of DBA must know commands. –Get the db details EXEC SP_HELPDB ‘Db_name’ –know the definition of the objects EXEC SP_HELPTEXT ‘object_name’ –Identify the size of database and table EXEC SP_SPACEUSED –Know the details of the disk drives EXEC MASTER..XP_FIXEDDRIVES —Quick view of SQL server sessions EXEC SP_WHO2 –It’s advanced version of sp_who2 but not shipped with SQL server.Get it from the following link. EXEC SP_WHOISACTIVE[…]
Read moreTag: dba
SQL Server Always On-Secondary database is NOT Synchronizing
Due to disk space crunch secondary database had gone into not synchronizing mode and it remained into that state even[…]
Read moreSQL server 2012: Kill SSIS package Execution in Integration Services catalog
Kill SSIS package in Integration Services catalog using tsql
Read moreSQL Server -Window XP useful commands for DBA
run>msinfo32 It gets the system information like OS, version name, components and many more. run>sqlservermanager11.msc Opens the SQL server configuration[…]
Read more