Sql Server Check the status or progress of backup job

Posted by Sqltimes
On October 30, 2013
0 Comments

Quick one today: Sometimes when I run manual backup processes, I want to check how far along has it progressed and its current status. There is an easy way to do this. As you know, the DMV ‘sys.dm_exec_requests’ has information about current requests to the database. If we query that and join it with ‘sys.dm_exec_sql_text’ […]

Posted by Sqltimes
On October 20, 2013
0 Comments

We have a lot of virtual machines (VM’s) in our environment. Every day, the push is more and more to have database servers as VM’s as well. Our infrastructure team, when they create new VM’s, they use templates. From their perspective, it’s a lot easier when you have VM templates. You need a new web […]

Posted by Sqltimes
On October 19, 2013
0 Comments

Quick one today. Occasionally, in my development environment, when I run CHECKDB, I run into this error: ERROR: Operating system error 665(The requested operation could not be completed due to a file system limitation) encountered. The error message is pretty vague and does not give me any leads to troubleshoot the issue. But upon some […]

Posted by Sqltimes
On October 13, 2013
0 Comments

This is really awesome !! You can split a partition (filegroup) with data without resulting in any data movement. Imagine a partitioned table with partitions for each month of a calendar year going to a dedicated file group. Each month data goes into its own partition and as you move forward, the sliding window opens […]

Posted by Sqltimes
On October 12, 2013
0 Comments

In a VLDB environment, diagnosing performance issues is both an art and science. There are several correct ways to identify the reasons contributing to the performance issue and help define the scope. Sql Server as a database engine is a resource intensive software. Not because of Sql Server, but what Sql Server, as a database […]

Posted by Sqltimes
On October 11, 2013
0 Comments

Another quick one today. The counter “Process(sqlservr)\% Processor Time“, is monitored frequently, to see how SQL Server is consuming CPU resources. This helps put things in perspective as to how existing resources are being utilized; If it’s efficient or does it need any tweeks. One counter that, we capture as part of regular monitoring is: Process(sqlservr)\% […]

Posted by Sqltimes
On October 6, 2013
0 Comments

Quick one today: This is something I use, frequently, in our performance lab environment to reset wait & latch stats counters before every volume testing (Performance Testing). [sourcecode language=”sql”] DBCC SQLPERF(‘sys.dm_os_wait_stats’,CLEAR) GO DBCC SQLPERF(‘sys.dm_os_latch_stats’,CLEAR) GO [/sourcecode] Surprisingly, it does not reset all the DMV’s. Only these two DMV’s. May be this is by design. Hope […]

Posted by Sqltimes
On October 3, 2013
0 Comments

A couple of days ago, I ran into this interesting error message. As I was preparing some diagnostic queries, to add to our Query Library, I was playing with some DMV’s & DMF’s (Dynamic Management Views & Functions) to gather some under-the-hood details about our Production Sql Server instance. When I JOIN’ed system views with […]

Sql Server Check the status or progress of backup job

Renaming computer name does not update Sql Server meta data for @@SERVERNAME

DBCC CHECKDB ERROR: Operating system error 665(The requested operation could not be completed due to a file system limitation) encountered.

Sql Server Table Partitioning: How to SPLIT a partition with data without causing any data movement

Sql Server: Avg. Disk sec/Transfer – Disk Latency resulting in slow I/O performance

Sql Server: Process(sqlservr)\% Processor Time

Sql Server Reset DMVs Counters

Sql Server Error Correlated parameters or sub-queries are not supported by the inline function sys.Dm_io_virtual_file_stats