Configure Distribution Database

In this blog, we are going to learn about the Distribution database, how to configure the Distribution database, and how many jobs get created during the configuration of the Distribution database. Distribution Database Distribution Database is a system database. It contains many objects that keep replication metadata and replicated data information. Each Publisher is linked […]

Read more
SQL Database File Wise Disk Space Monitoring

As a DBA, you get alerts many times regarding the database file space issue. To address the issue, you may be following the steps. Which is the particular database file in the database which is having less space? How much disk space available on the physical disk where the file resides? The below script will […]

Read more
Microsoft Data Platform – MVP 2017!!!

I’m very pleased and delighted to share that I have been awarded Microsoft Most Valuable Professional (MVP) award 2017. This is my first time obtaining this award and the news comes via an email in Last week, it is a great honor to be given this award. Finally, the dream has come true, the only […]

Read more
Read Statistics Histogram using DMV

DMV: sys.dm_db_stats_histogram (object_id, stats_id)  For a long time, the DBCC SHOW_STATISTICS command was the only way to get information about statistics. It displays current query optimization statistics for a table or indexed view. It was always a painful task, if you wanted to capture output of the DBCC SHOW_STATISTICS for all tables in one go. […]

Read more
After migrating SQL Server from 2005 to higher version, the waits type PAGELATCH_UP increased

Recently, I experienced an interesting issue where I found SQL Server wait type PageLatch_UP went up drastically after migration. Let’s walk through to understand the problem and its solution. Problem After migrating SQL Server 2005 instances to higher versions – SQL 2008/SQL 2008 R2/SQL 2012/SQL 2014 and SQL 2016, I found the most of (not all) […]

Read more
SQL Server Service Information

DMV: sys.dm_server_services Microsoft SQL Server 2008 R2 SP1 and SQL Server 2012 has a new set of DMVs. One of them is “sys.dm_server_services” which  return a whole host of important information relating to the SQL Server services that includs; Service Name Startup Type Startup_Type_Desc Status Status_Desc Process_id Last Startup Time Service Account, File Name Is_Clustered Cluster […]

Read more
Disk Space Monitoring using SQL Server DMV

DMV : sys.dm_os_volume_stats Being a SQL Server database administrator, you may often receive alerts or asked by Senior DBAs to check, if the disk space is running out of space on SQL Server. Before SQL Server 2008 R2 SP1, the best way to check on available disk space from within SQL Server is to use the undocumented […]

Read more
When was SQL Server installed?

In this blog post. Let us learn about how to retrieve date and time when the SQL Server was installed. To retrieve the SQL Server Installation date, we have to check the login “NT Authority\System” creation date which gets created at the time of SQL Server installation. You can check the SQL Server installation date and time […]

Read more