Also look at sys.dm_os_wait_stats. That's going to tell you specifically what is causing things to slow down on the server. It won't narrow it down to particular processes or anything,...

Yeah, it does sound like contention. Since it's a restore, the most likely place is IO, but it's also going to affect CPU, memory, etc. I would look at sys.dm_exec_requests...

This is seriously fascinating stuff. You have to know that as more and more data about all of us becomes publicly available that it will impact employment. I suspect, based...

If you get desperate, and I've been there, you can issue a CHECKPOINT command, backup the log, issue another CHECKPOINT, and backup the log again. That frequently clears the tail...

If you have lots of ad hoc queries, it's not a surprise that your procedure cache hit rate is low. As a matter of fact, that would be normal. Optimize...

There are actually a number of companies that have gone out of business or suffered major losses due to database issues. I wrote an article about them and published it...

Glad to hear it's fixed.

Just curious though, why not use a PowerShell type of step in SQL Agent for a PowerShell script?

It does depend on how your security is set up, but you can set a database to restricted_user. This will make it so that only logins with privileges as SA...

Lynn Pettis (3/31/2013)

---

Yes, I am sure about doing this, but I am both anxious and excited about going. It may not be the safest place but having talked to...

I so wish we had voting here. i just want to vote up Gail's answer & move on. Trace flags and and the system_health Extended Event session would be my...

If you want monitoring on both SQL Server and Oracle, your choices are limited. Quest software (Dell?) has a tool that can do both. Confio has two tools that each...

Not to mention that adding all those checks into a single transaction increases the time that transaction will run which increases the likelihood of blocking and deadlocks.

Without seeing the queries or the execution plan, everything that follows is just a vague guess.

If you're seeing scans, it means either that you don't have the right indexes in...

Steve Jones - SSC Editor (3/28/2013)

---

Good answer: http://meta.stackoverflow.com/questions/167452/what-are-the-most-effective-ways-to-guide-new-users/167510#167510

I know we don't keep people away, but treating them with respect, somewhat without regards to how snippy they may appear, is something...

ScottPletcher (3/28/2013)

---

Grant Fritchey (3/28/2013)

---

ScottPletcher (3/28/2013)

---

There must be more fragmentation in a history table than a current-data-only table.

For single row lookups, this is not really a performance hit.

But for table scans,...