IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial

Tag Archives: SQL Server Active Sessions

SQL Server DBA Scripts All in One – Useful MS-SQL ( DBA ) Database Administration Scripts

Mehmet Salih Deveci May 30, 2019 SQL Server DBA Scripts 16

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

SQL Server Update Database Statistic

Mehmet Salih Deveci March 12, 2019 SQL Server 0

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

SQL Server Wait Events -3

Mehmet Salih Deveci March 11, 2019 SQL Scripts, SQL Server, SQL Server DBA Scripts 1

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

SQL Server Wait Events -2

Mehmet Salih Deveci March 11, 2019 SQL Scripts, SQL Server, SQL Server DBA Scripts 0

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

SQL Server Change TempDB File Location

Mehmet Salih Deveci March 7, 2019 SQL Server 1

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

SQL Server Wait Events -1

Mehmet Salih Deveci March 7, 2019 SQL Scripts, SQL Server, SQL Server DBA Scripts 1

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

SQL Server Database Objects Statistics

Mehmet Salih Deveci March 7, 2019 SQL Scripts, SQL Server, SQL Server DBA Scripts 5

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

SQL Server Active Sessions and Status

Mehmet Salih Deveci March 7, 2019 SQL Scripts, SQL Server, SQL Server DBA Scripts 1

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