Yeah, that's pretty normal. SQL Server ensures that each of the transactions within it maintains ACID properties (Atomic, Consistant, Isolated, Durable) through the use of locking. This prevents data from...

You need to wait.

Long running transactions that fill the log need to be rewound, which can take longer than the original transaction. Rebooting doesn't help.

In the mean time, I'd suggest...

You need a much more thorough collection of data in order to determine the causes of the high cpu. Yeah, it could be SQL Server, but from what you've said...

Alex-668179 (5/31/2012)

---

"every table within SQL Server should have a clustered index"

Fine, but should it then also always be the (preferably meaningless?) primary key? Or an index that is more likely...

jasona.work (5/30/2012)

---

OK, I'm reviving this topic with a new (somewhat related) question:

How do you feel about the SQL in the City[/url] events?

I took a look at the agenda for the...

anthony.green (5/30/2012)

---

Thanks Grant, I just tried monitor.red-gate.com on the iPhone and works a charm especially the analysis part with the graphs. Now my question is, does monitor use the...

Mark Fitzgerald-331224 (5/29/2012)

---

*.sqlplans attached. (SQL below used to create the sample data - know this isn't optimal but didn't want to spend too much brain power on it, got bored...

anthony.green (5/28/2012)

---

Grant, on the Droid OS, does it render SSRS reports properly?

I know Safari has its limitations, so I use the MobiSSRS (free version) app instead of Safari which works...

Disparity between estimated & actual points towards either bad statistics on the data, or good statistics, but the data is skewed which is causing bad parameter sniffing for some values....

Jeff Moden (5/27/2012)

---

Revenant (5/26/2012)

---

Steve Jones - SSC Editor (5/25/2012)

---

Jeff Moden (5/25/2012)

---

Brandie Tarvin (5/25/2012)

---

Anyone else find it inconvenient that MS wants people to have SysAdmin access in order to work the...

When you're defining a join, you should define the columns that join the two tables together. So that you're ON condition is something along the lines of

A.ID = B.ID

If...

Gianluca Sartori (5/25/2012)

---

paul.knibbs (5/25/2012)

---

He did say he felt SQL Agent is more robust than Windows task scheduler, but it would be interesting to know why he feels that...I've rarely run...

If you can post the execution plans, I would be guessing less, but, guessing, I'd say that it's probably a parameter sniffing issue. Take a look at the estimated values...

This is a classic issue for backups and one that leads to severe problems when you try to recover these backups. I detail this issue, along with a few others,...

It's certainly possible that's the cause, but I'd be more concerned that the query is identical between both databases and, more importantly, that the statistics are updated in exactly the...