Going by High Keylocks and RID,

1. check if your stored procs are explicitly using ROWLOCK table hints while accessing the tables ( tip : search syscomments or generate script...

This usually happens when you put a image of another computer on your machine.

All you need to do is : -

1. sp_dropserver --- drop the srv.... servername

2....

BOL says,

Virtual Interface Adapter (VIA) protocol works with VIA hardware. Consult your hardware vendor for information about using VIA.

Question:-

1. Why do you need to enable VIA ?

2. Do you have...

I would start investigating by comparing the

RESTORE HEADERONLY and RESTORE FILELISTONLY information for the regular backup file

and this miscellaneous backup file and see if there are any differences.

Use "alter database" and "alter table" commands with COLLATE clause.

Can you please explain your base problem ? Looks like this is a subpart of your problem ???

I can think of only 2 options right now, both need downtime :-

1. Create new filegroups on the new 50GB Luns, drop and recreate clustered indexes on the new filegroups.

2....

Bol says, use

STATS_DATE ( table_id , index_id )

... tells you when were the statistics last updated.

When designing, the thumb-rule is no. of spindles is directly proportional to IO throughput.

I would spread my high-transaction tables such that they get many spindles.

i.e. Create clustered index for these...

That was a good one...

No. Total_worker_time is nothing but CPU count. No need to divide. Its the amount of CPU your process used thats it.

Page faults happen when a thread being processed doesnt find the required data in the physical memory and has to page it into the memory.

Your problem looks like a memory...

Tip :-

Once you implement partitioned table and are going to implement Sliding window.

Make sure that you split and merge partitions which are empty.

Splitting or merging a partition(s) containing millions of...

My thoughts:-

1. In Microsoft Server 2003 R2, you have an option of dumping your perfmon counters into a table.

Though this would result in lots of data and...

If i understand this correctly, your table is not available for 2 hours because you are loading data into it ?

How about partitioning the table ?

1. Partition your main...