george sibbald (2/28/2014)

---

profiler as a server side trace is another option. I presume would be more intrusive than the trace flag though, but gives a graphical representation.

Grant, is system_health extended...

That's a lot of deadlocks. You might actually have impacted performance using the traceflag.

dan-572483 (2/28/2014)

---

I did run dm_indexes_physical_stats on the table and the indexes were all either 0 or 0.45 percent fragmented. So assuming DBCC passes, is it probable that the...

I'd suggest running DBCC CHECKDB. If that passes, you're OK in terms of corruption. That index may still be fragmented. Actually, pretty sure it will be.

There is only limited ability of distributed queries to get and use statistics, so, when it can't get them, it just moves the entire data set over. You can read...

I'd keep the app offline yes. Or, you have to deal with killing connections until you can get the database offline, then the app will have X number of errors...

Yep. That'll work. Or you can export the schema to a T-SQL script and then import that.

I have seen an issue with it, but only on a system that was getting amazingly huge amounts of deadlocks. For the average system, even the average problematic system, I...

If it's in Simple Recovery, the only thing you can do to keep the size smaller is reduce the transaction size and count. If you're seeing large logs after maintenance,...

Koen Verbeeck (2/28/2014)

---

Grant Fritchey (2/27/2014)

---

Koen Verbeeck (2/27/2014)

---

There's a new developer conference in Belgium: Techorama (which replaces two conferences: the Community Day, an organization of all the user groups, and TechDays,...

Koen Verbeeck (2/28/2014)

---

Grant Fritchey (2/28/2014)

---

And if you need to you can use ASC or DESC to directly control the sort order of ORDER BY, but ASC, or ascending, is the...

It's pretty unusual to only ever see IO related waits. But yeah, assuming the data you're providing is correct and you only ever see about 20 seconds of waits within...

If it's at the last step its dealing with all the logs, rolling forward or rolling back transactions. That can take a while.

Have you looked at sys.dm_exec_requests to see if...

And if you need to you can use ASC or DESC to directly control the sort order of ORDER BY, but ASC, or ascending, is the default behavior.

If you really want to see how intellisense ought to work, check out Red Gate SQL Prompt[/url].