Tag Archives: MEHMET SALİH DEVECİ

Hi, Especially during the creation of Test environment, you may need changing database name as SQL Server DBA.

Hi, You may need to change database recovery model of SQL Server.

Hi, Sometimes application developers or client offers you to kill any session or sessions group like SQL Net Client, or JDBC Client sessions, RMAN sessions or All sessions.

Hi, TempDB is one of the most important system databases of SQL Server.

Hi, You should find that which of wait events are in the SQL Server database.

Hi, Database objects stats should be up to date for making the right decision of SQL Server optimizer.

Hi, Most frequently task of DBA is monitor database and which session is active and which is inactive or which one is blocked.

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

Hi All Indexes in the SQL Server database will be fragmented After related tables got many update, delete transactions.

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.