Thanks a million Steve for your responses.

I think the next step is a case with MS, according to the history of this server similar symptoms appeared a few months ago...

Hi Steve, thanks again.  No CLR enabled and system was rebooted after patching, we also applied CU3 last night and rebooted and issue still occurrs.  No consistency checks were running...

Thanks Steve, the server a high amount of available memory so that doesnt seem to be the issue, I'm wondering what might cause the MemoryClery_SOSNode to increase massively

Admingod (8/12/2014)

---

When scheduling maintenance plan on SQL server for e.g. index rebuild + Integrity check etc.

do we have to schedule these tasks to run on different time for different server....

I haven't tried this but a simple googling will get you the answer.

http://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/

Also, add a step to update your documnetation as part of the move. 🙂

Might be a silly question Erin but did you try logging on the SSMS using the Audit SQL login and see if you can access both the databases?

A couple of things, look at your local security settings to ensure the OS is not taking memory[/url] from SQL.

Also, before changing MAX memory setting, you need to use perfmon...

Check the OLAP log to see if there is any info. You can find the location of the log on the advanced tab of the SSAS server in SQL...

I've implemented a centralised SSIS hub. Its a VM and works well licence wise if you VM host is licenced correctly. Also, allows for better version control of...

expand the drive, then plan to add another separate drive (RAID 10 if possible) and move all you...

I'd first try to update the stats on the database that has the performance issues to see if that helps. Looks like you have alot of free space on...

Rebuilding the index will be fully logged in the transaction log. You could bring down your whole database server if you dont get this right.

Is the reason...

what's the message when you run each of those commands separately from SSMS?

Who's the owner of the SQL Agent job?

sounds like the database you are having issues with could still be backing up at the same time you are trying the rename the file from 01 to 02 or...