Hi, Most frequently task of DBA is monitor database and which session is active and which is inactive or which one is blocked.
Read More »Tag Archives: SQL Server 2012
SQL Server Index Usage Stats
Hi, SQL Server DBA should monitor all indexes and which of indexes are using and which are not.
Read More »SQL Server Rebuild Index Query
Hi All Indexes in the SQL Server database will be fragmented After related tables got many update, delete transactions.
Read More »SQL Server Performance TOP IO Query -1
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 Performance TOP CPU Query -1
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 Collection Inventory Script -1
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 2012 SP2 Upgrade
Merhaba Arkadaşlar, Bu yazımda sizlere Windows Server 2012 üzerinde çalışan SQL Server 2012 SP1 veritabanının SQL Server 2012 SP2 ( Service Pack 2 ) ye upgrade edilmesini anlatacağım. Bu Service Pack …
Read More »SQL Server 2012 Kurulumu
Merhaba Arkadaşlar, Bu yazımda sizlere SQL Server veritabanının yeni sürümü olan SQL Server 2012 inin kurulumunu anlatacağım. Kuruluma geçmeden önce bir takım ön bilgiler vermek istiyorum. Microsoft Ekim,2011 de SQL …
Read More »