Tag Archives: SQL Server useful script

Hi, SQL Server DBA should monitor all indexes and which of indexes are using and which are not.

Hi, You should find that which of wait events are in the SQL Server database and status of currently waiting tasks.

Hi, If you got slowness complaint from customer,  you need to monitor SQL Server Instance and database which sql is consuming a lots of resource.

Hi, To summarize the backup we can say, Copy of Stored Data to Disk or Tape In case of unexpected errors or disasters, this copy can be defined as Restoring …

Hi, Partitioning is to create our very large tables or indexes in separate segments.

Hi, You want to learn all Inventory of SQL Server when you connect to SQL Server database for the first time.

Hi, Disk IO Statistics are very crucial for SQL Server Performance criteria.

Hi, The use of Index in the SQL Server database occurs in environments that require the most performance, speed, and memory savings.

Hi, Generally There are many databases on SQL Server Instance. Running databases into same instance is very important for SQL Server license and consolidation.

Hi, Managers and customers are asking frequently what is the database size growth.