Hi - straight selects, no temporary table / CTEs or anything like that

Reasons beginning with the letter P ... :rolleyes:

I'll go away...

In sysdatabases the following are listed

snapshot_isolation_state_desc = ON

is_read_committed_snapshot_on = 1

This setting was recommended by the vendor

I also have some further news about the page contention - we have a ridiculous...

This database is weird all over 🙂

I'll double check what's configured, I may have misheard, I know that it's using tempdb to help with contention and I always get them...

I have some more information -

The queries that are suffering from contention are selects. The db ID in sysprocesses definitely shows as the user database and we're now using a...

Thanks - that makes things a lot clearer 🙂

Thanks - we're going to keep monitoring it, I don't have any of the affected queries unfortunately.

The CPU was being hammered at the time, is it possible that this could...

Hi Gail, Kevin - thanks for the replies.

This database doesn't have any create / drop tables, just in tempdb (multiple files there to avoid this issue)

thanks - we're nowhere near this happening yet, just had some questions about 'can this be moved in x amount of time?'

It will be tested 😀

Don't know of any utility, but I think it would be doable in Powershell - you can get all the SQL config bits using invoke-sqlcmd and all the Windows bits...

ah cheers, so it's the OS that's the dependency & that answers my question very nicely 🙂

Thanks for this, I have an upcoming SQL 2012 install using Netbackup and would have hit the same problem 🙂

That's brilliant !

Thanks very much :w00t:

Ok, I popped the results into a temporary table. It's only giving the results (rn = 1) for either the first or the last year (depending on whether I remove...

I am not sure how the above worked, but it returned something !