Hi, SQL Server DBA should monitor all indexes and which of indexes are using and which are not.
Read More »Tag Archives: Mehmet Deveci
SQL Server Wait Events -2
Hi, You should find that which of wait events are in the SQL Server database and status of currently waiting tasks.
Read More »SQL Server Performance TOP CPU Query -2
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.
Read More »SQL Server Backup Check
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 …
Read More »SQL Server Check Table Partitioned
Hi, Partitioning is to create our very large tables or indexes in separate segments.
Read More »SQL Server Collection Inventory Script -3
Hi, You want to learn all Inventory of SQL Server when you connect to SQL Server database for the first time.
Read More »SQL Server Performance File IO Statistics
Hi, Disk IO Statistics are very crucial for SQL Server Performance criteria.
Read More »SQL Server Missing Index
Hi, The use of Index in the SQL Server database occurs in environments that require the most performance, speed, and memory savings.
Read More »SQL Server Databases CPU Usage Stats
Hi, Generally There are many databases on SQL Server Instance. Running databases into same instance is very important for SQL Server license and consolidation.
Read More »SQL Server Database Size Growth using Backup history
Hi, Managers and customers are asking frequently what is the database size growth.
Read More »