SBS 2011 runs very slowly on a high spec server, which also causes the backup to fail.

A 1 year old SBS 2011 server with Xeon processor and 32GB RAM, has started running very slowly again. This last time this occurred was two months ago and after several reboots, with a change of AV, swap file location and C: drive space increase, it started working normally again.

After a further reboot due to more Windows updates ( which were successful and different from two months ago ), it has reverted back to running very slow again, which seems to also cause the SBS backup to time out with a 'Creation of the shared protection point timed out. Unknown error (0x81000101)'.

There is no obvious cause in the event viewer logs and there is currently 42GB free out of 120GB on the C: partition, whereas previously the space was around 10GB when the problem started, although disk space may be unrelated.

However about half of the VSS writers seem to be in a 'Retryable error' state (  when entering vssadmin list writers from a command prompt ), which will require a further reboot to at least temporarily resolve. It may be that the failed backup procedure then causes the writers to fail again.

In the processes area of Task Manager, CPU usage is between 90-100% most of the time and physical memory is around 84% usage. The top processes using memory are the Microsoft Exchange DB Store ( 11.5GB ), SQLserv ( 2 totalling 3.6GB ) and IIS Worker Processes ( 4 totalling 1.8GB ).

It is my understanding that Exchange and SQL can utilise any resources that are free and then release them when another process requires them, which may account for the high usage, but it is unclear what is causing the VSS writer errors. Also there are only 5 users, with no additional 'resource demanding' programs installed.

What steps can be taken to troubleshoot this further, with a view to improving the performance again, to stabilise the VSS writers and to stop the backup from timing out?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Larry Struckmeyer MVPCommented:

While free RAM is unused RAM and some consider it a waste, you should reduce the amount of RAM Exchange uses, and probably should consider reducing that consumed by SQL.  Regardless of what we are told about Exchange, the latest versions are very greedy for RAM by design to reduce the IO hits on storage systems.  This is fine in a large org with dedicated Exchange servers with 192 GB RAM, but in our world it has not been so successful.  Here is the best resource for controlling Exchange and RAM:

Do that and revisit SQL should the RAM still be in question.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cliff GaliherCommented:
Your CPU usage is unusually high for the number of users you have. And while you posted the top memory using processes, you didn't list the top processor zappers. If your CPU is pegged, you'll get poor performance. I'd start there. Knowing your disk subsystem config could be helpful as well.
itcroydonAuthor Commented:
I couldn't match up the instructions in the link to the advanced AD options in SBS 2011; however I followed through the following article instead.

Unfortunately this doesn't seem to have taken effect, but for the moment the store.exe size is less than 1GB. Also although CPU and memory usage are currently running at less than 50% after the reboot ( which did also clear the writer 'retryable errors' ), the server still seems to be running incredibly slow.

Also I have seen in the past where SQL can cause this type of issue on SBS, but unfortunately I cannot login to SQL Server Management Studio. It allows me to browse to 'network' and select the server name, but when Windows Authentication is selected and the new administrator details, it displays the following error message :

'a network-related or instance-specific error occurred whilst establishing a connection to SQL server. The server was not found or was not accessible'.

 I am not sure what logon details are required or whether these can be amended, as we didn't setup the server originally!
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

itcroydonAuthor Commented:
Further to my previous post, I have managed to right click on the sqlservr.exe process and set this to low priority, which has provided some performance improvement. Time will tell whether this is enough for the backup to run successfully.
itcroydonAuthor Commented:
Cliff, the top processes within CPU resource monitor are changing rapidly, but the main ones are :

Microsoft Block Level Backup Engine Service
Windows SBS 2011 Standard Console
Resource and Performance monitor
IIS Worker Process ( X 2 )
SQL server Windows NT - 64 bit
Host Process for Windows services
Microsoft Office SharePoint Portal & Timer ( sometimes terminated )
Cliff GaliherCommented:
Rapportmgmtservice is a client application. Why is that on your server?
In resource manger please confirm the drive read/write per/sec. I have seen on a few sites that the SBS 2011 monitoring process tends to grind the server to a halt. The dead give away is the drive showing 99%-100% all the time. There is a script you can run to reset the monitoring database if that's what's happening.
itcroydonAuthor Commented:
I am suspecting that it is SQL related, although at the moment both CPU & Memory usage are below 50%, but the writer status is showing as not known. It may be however that this may change during the backup, which then causes it to fail.

I have managed to login to np://./pipe/mssql$microsoft##SSEE/sql/query to limit the memory used, but not specifically the monitoring SQL database and so I would be interested in having the script on standby.

Rapport and another surplus utility have now been removed.

The server will reboot just before the next backup tonight and so we will see if anything changes or not.
Thomas RushCommented:
Incremental backups are great for saving time -- but please run a full backup job periodically.   The reason is that to recover from a full+incremental backup, you need to load the full, and *every* incremental up to your restore point.   If you go on for months without running a full, then you'll have a hundred, or hundreds, of incrementals to load.  This can not only take a long time, but -- more importantly -- if *any* of your incrementals can't be read, that's the end of your restore.  You can't get to a more recent restore point.

(Yes, it's possible that you'd been running incrementals before, and that you'd never noticed the performance problem... but after rebooting the NAS, the backup application could have decided it was time for a new full backup, and now you're finally noticing how bad performance always has been)

Now, what about the performance?  Use PerfMon in Windows to check your network and disk performance on the server.  
Do run a copy from the server with slow backups to the NAS and see what speed you get on a straight copy -- if it's also in the 10MB/sec range, perhaps your server NIC is connecting at a slower speed than it's capable of.  Or maybe it's the switch (how long since the switch has been powered down?  What happens if you move the server to a different port on the switch?).
itcroydonAuthor Commented:
Somewhere along the troubleshooting process, the performance has returned back to more normal levels and the backup no longer times out ( backup is via USB and so NAS / Network issues did not apply ).
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.