From http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/performance_tuning_waits_queues.mspx:

So it seems there is some IO latency in your system as well, although parallelism is a much larger concern.

If you need...

CXPACKET 1462255

PAGEIOLATCH_SH 186881

CLR_AUTO_EVENT 172800

BACKUPBUFFER ...

I'm assuming you...

I'm probably off the mark, but, make sure user actions, such as a button click are not wrapped in an explicit transaction. That would cause intensive blocking and account for...

Also, the one thing I should have suggested to start with: use the Database Tuning Advisor, DTA, to get index recommendations on your slow query.

Save your query in a file.

Open...

Hmm, I think HTTP Endpoints are only called from a Web Service, not from T-SQL, so perhaps the analogy with linked servers was not as close as I thought...

Just thinking...

I don't have an answer unfortunately, but my question is, why is this posted under CLR Integration. I hope you are not using the CLR for this, you don't need...

I think there is a "Transfer Logins" task in SSIS as well.

Unless...

Use "SET NOCOUNT ON" at the start of your stored procedures to eliminate unnecessary network overhead due to retrieval of extra datasets any time data is fetched from/inserted into the...

Also, examine your execution plan. A hash-join operator, if present, is an indication you are missing indexes on join columns.

To help narrow down which indexes you need to add, here is a query you can use (adjust the "migs_adv.index_advantage > 10000" filter according to your needs):

--Get missing indexes

SELECT

index_advantage

,user_seeks

,last_user_seek

,avg_total_user_cost

,avg_user_impact

,...

As GilaMonster mentions, store your backup files - including txn-log backups - somewhere other than your local server box. One strategy would be to use something like Windows Flashcopy or...

Jpotucek (3/15/2008)

---

Installing 2005 Stnd for the first time and I had to restart the install because IIS was not installed on the box.

My Infrastructure guys kinda gave me a hard...

Actually, I'm not sure this explains it. The TRANSACTION is wrapped around the TRY/CATCH block, not the other way around.

I would have expected the failure of the transaction to be...