Did not mention before- can DB Mirror be the reason for increased Locks: AverageWaitTime?

Thanks,

Thanks, David.

I did not kill any query but I did find application that caused this huge wait time. Then I updated statistics on all tables in particular DB and bingo-...

Thanks gents- it seems that the only way we can switch roles back is over manual faiover

Thanks, Steve, but this approach deals with failover (manual). I thought there is another way (not related to failover). Probably I was wrong

check modify_date for table_name (not PK), i.e.

select modify_date, * from sys.objects where name = 'accounts'

and you will get what you are looking for 🙂

“sys.objects” contains “modify_date”. This data can help you as in accordance with BOL “If the object is a table or a view, modify_date also changes when a clustered index on...

Actually BOL mentioned about it- both servers should have same Editions- both Enterprise or both Standard. But I decided to check myself- it's true. I need to install Enterprise Edition...

Thanks Adam-

I just tryed and found that you can not use pair Enterpise-Standard Sql servers for mirroring.:w00t:

Thanks Doug for your response.:)

Frankly I have no idea why page file size is 4GB (I inherited this server). But I know for a fact that my another similar Sql...

Probably this MS article has answer for your question:

http://msdn2.microsoft.com/en-us/library/ms191160.aspx

From my experience (just completed almost same project):

1. For sliding window- single filegroup (FG) is easier to control partition placement;

2. If you put some FG on the same drive you...

For space used actually I used "sp_spaceused". Dbcc Config I used to find number of allocated pages. If query requires Clustered Index Scan execution time depends on this number (if...

Actually I checked with "updateusage = true".

Thanks

Jeff,

What you explained makes perfect sense and I thought about it.

But what confused me is the fact that table size was not increased after conversion (I just double checked...

Thanks Sarah- working like a charm