Thank you, that's good to know.

However, I'm looking for some setting within report designer in VS, if at all available.

GilaMonster (3/17/2008)

---

I'm so used to the output of 1204 that it's not a challenge to read anymore. Could be that this is not a good thing.

Is the output of...

Thank you Jeff, I'll take a look at that link!

I haven't used the new flag much either.

A while ago I wrote an app that went and parsed the ERRORLOG text file extracting deadlock info into a database for reporting....

GilaMonster already mentioned it, but here is a slightly expanded version:

Stop and disable all applications that make connections to the instance of the database engine, including Backup Exec (Veritas) remote...

Jeff Kelly (3/17/2008)

---

hey guys,

i know this is a somewhat old thread, but i'm just starting to work with SSRS and i'm seeing the same problem.

As mentioned, it seems to be...

Trace flag 1222 is new to SQL Server 2005 and gives XML-like output, which is much easier to manipulate programmatically, should one be interested in producing a report.

I don't think...

george sibbald (3/17/2008)

---

so high i/o queries benefit from parallelism? And one hope queries in OLTP do not produce high i/o (hence comment about tuning, by which I presume you mean...

george sibbald (3/17/2008)

---

....which brings me on to a question, is parallelism a good thing in the database engine?

Amount of times I see CXPACKET waits and PAGEIOLATCH_* waits on parallel queries,...

julia.nicholas (3/17/2008)

---

Thanks guys (and girls) for all the tips. I have the VERIFYONLY being run as part of the daily backup (now I know in 2005 this is actually...

This is a good link on deadlocks:

http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

Poor indexing, unnecessarily long transactions are the 2 major culprits of persistent deadlocks.

Generally, deadlocks are *OK* if they do not occur too frequently. You...

Check the SQL Server Browser service is running too.

I made the same mistake once.

Fortunately, I knew the password of the SQL Startup Service domain account and was able to connect as that acct.

Thanks all, good to know of...

If you are still concerned about heavy IO, run the following query to get the top 10 costliest queries in terms of IO:

SELECT TOP 10

[Average IO] = (total_logical_reads...

Correct, the SQL optimizer is using (potentially)...