Hi,

Has someone been messing around with the public permissions? Can you run dbcc checkdb on the database 'mssqlsystemresource'. This database is another system database that is hidden in SQL so...

Hi,

I can't for the life of me remember the term for doing this but if you grant the stored proc create, insert, update, etc then don't provide the users with...

Hi,

We restart our active/active clusters at different times to allow the instances to failover and then allow failback for the instances so they end up on the correct node after...

You may want to check out these DMV queries to help see where you have a bottleneck but with low page life expectency and paging I'd be thinking memory.

Hi,

I don't know if there is enough information provided here to give you a definite answer. Is 150MB too low? Well it kind of depends. Are you seeing paging on...