Since I started actively participating in SQL community, I found it is very common that people will approach to seek help on their SQL related issues. I do love to help people because it is always a win and win situation for both of us. Recently, I had a phone conversation with one of the […]
Figuring out Time-Out Prone queries
Read more
Recently, I was helping one of the community attendees on the SQL Server Query Time-Out issue. Once we are done with troubleshooting, he asked a very excellent question; “I am dealing with very critical OLTP systems. As my company has been expanding the business, the data is rapidly growing. It is causing a lot of […]
Extracting Deadlock information using SYSTEM_HEALTH Extended Events
Read more
Extended Events is a powerful feature that was introduced into SQL Server 2008 and onwards. It keeps historical system health information of the SQL Server instance. Today, we are going to explore how quickly we can read the Deadlock information using Extended Event – “Without passing the default location of the extended events trace files” The system_health […]
Log File Space Issue Monitoring Using SQL Server DMV
Read more
As a continuation of “Database Monitoring using DMV” series, this blog will cover how quickly you can address the log file space related issue. Below are the previous blogs which you may find useful in your everyday job. Disk Space Monitoring Using SQL Server DMV SQL Database File Wise Disk Space Monitoring To address the […]
SQL Database File Wise Disk Space Monitoring
Read more
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 Statistics Histogram using DMV
Read more
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. […]
SQL Server Service Information
Read more
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 […]
Disk Space Monitoring using SQL Server DMV
Read more
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 […]
When was SQL Server installed?
Read more
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 […]