change the owner as part of a planned failover or do it should the database fail over of its own accord.

believe me, you need to run it this way to get full admin privileges.

when you run the installer are you right clicking on it and selecting 'run as administrator'?

please start a new thread

Hi, please post new questions in a new thread, you'll get a better response

you can check where blocked != 0 from master..sysprocesses table.

you can also use profiler now to trap information on blocks.

ooooh, you edited it 🙂

GilaMonster (7/22/2013)

---

Optimise for ad-hoc was only...

no problem

if your databases are not currently being backed up you need to get that set up immediately so go the easy route and use maintenance plans. You could look at...

If the drive is 40GB and your logs only take up 1.5GB, its not the logs causing the problem, so no need to shrink them.

Ask your server admins to look...

as the message says it is an advanced setting

sp_CONFIGURE 'show advanced options',1

RECONFIGURE

GO

sp_CONFIGURE ‘optimize for ad hoc workloads’,1

RECONFIGURE

GO

SQL_Surfer (7/19/2013)

---

Thank you. Thanks for the query to find out heavily used indexes. Using this, as far as statistics are concerned, we won't be able to capture _WA statistics but...

buffer cache and proc cache are separate so I don't think it would affect PLE directly. Are you actually seeing any memory related error messages?

with such a large CACHESTORE_SQLCP you...

that link does not expand for me.

MachineB (presumed passive node) will not be able to see the disks when passive so will not able to see the file system....