Tag Archives: sql server sessions

Hi, I will share SQL Server DBA Scripts in this post.

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

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

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

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, 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.