How is your server configured?

32 or 64 bit?

How much RAM, and what is the MAX Sql Server Memory?

Is lock pages in memory enabled and have you added the 845 trace...

Add this at the end of your insert statements:

declare @result varchar(500)

declare @urn int

declare Str_cur cursor

for select distinct urn from #tmp

open str_cur

fetch next from str_cur into...

Vertigo44 (4/4/2011)

---

John Mitchell-245523 (4/4/2011)

---

Sounds like you've got two instances on your server. Go on to the server and run SQL Server Configuration Manager. This will list all the...

Conray (4/3/2011)

---

Thanks Grant for your insight.

I am almost 100% sure that the long running query is causing the application connection (JDBC, ReportServer) to be disconnected.

Sure, i would go about to...

Why would you go for log shipping? Every...

It's relativly unusual to see a single resource deadlock, but it does happen. I've coined the phrase "intra object deadlock". I don't know if the phrase has been used by...

It looks like someone installed a db managment tool that either deliberatly or accedently added tables to msdb. This is not a good idea.

Tools like this may use the sytem...

You can definitely do this. I've got 4 VMs on my notebook. One is a Domain Controller, one's a SAN and the other 2 are the clustered servers. Memory tends...

Mirroring was designed for HA/DR, although there...

That was the complete error.

Besides all the details in the dump files, and...

Following on my previous post, look at this DMV.

dm_db_index_physical_stats(database_id,object_id,index_id,partition_number,mode) -- Function

Here's a typical example to run before and after changing an index.

select database_id, object_id, index_id, partition_number, index_type_desc,

alloc_unit_type_desc, index_depth, index_level, avg_fragmentation_in_percent,

fragment_count,...

Ninja's_RGR'us (3/1/2011)

---

Makes sense if the # of pages in the index increased a lot. Makes the seek much costlier where the key lookup wasn't that much of a big...

The RPC protocol is used when a client calls a procedure on a server. In SQL terms typically when an application server makes a procedure call against the database you...

Here's a great set of articles I found very helpfull.

http://www.mssqltips.com/tip.asp?tip=1687

http://www.mssqltips.com/tip.asp?tip=1698

http://www.mssqltips.com/tip.asp?tip=1709

http://www.mssqltips.com/tip.asp?tip=1721

There are a few gotchas around virtual SQL Server names if you have multiple named instances. If you intend runing Reporting...

Once the SQL Server Service has started, it is technically able to accept connections, but it takes a few seconds to attache the databases and make them available. This means...