Jim Lawrence
accessd at shaw.ca
Wed May 7 11:16:30 CDT 2014
I do know whether this is part of the issue but I have always been advised to turn off volume shadow copy, on active data drives, as it can be very resource intensive and runs independently of the data server...even when the server is under load. Oracle, manages its own roll backup so any processes that may affect active data management and resources are not allowed to interfere. Perfmon is a great system monitor as it runs at a low level, takes very little resources and is always running. Many of the DBA guys, I have known, swear by the tool. Could have used poolmon a few years ago. (Its a good article.) Jim ----- Original Message ----- From: "Martin Reid" <mwp.reid at qub.ac.uk> To: "Discussion of Hardware and Software issues (dba-tech at databaseadvisors.com)" <dba-tech at databaseadvisors.com>, "Discussion concerning MS SQL Server (dba-sqlserver at databaseadvisors.com)" <dba-sqlserver at databaseadvisors.com> Sent: Wednesday, May 7, 2014 6:35:46 AM Subject: [dba-SQLServer] FW: SQL Cluster See below from one of my colleagues. Anyone have any comments/advise/ideas? Was bounced when I included the screen shots. Cross Posted to DBA Tech list. Martin We still have a large amount of memory being used as "Nonpaged Pool" on sp-sql-d3 and sp-sql-d2, but not sp-sql-d1. I have investigated based on the following blog: http://blogs.msdn.com/b/ntdebugging/archive/2012/08/30/troubleshooting-pool-leaks-part-2-poolmon.aspx It looks like there may be an issue with the Windows Volume Shadow Copy Driver "volsnap.sys". Where to go from here, I'm not sure - but this may be an avenue worth exploring. The good news - SharePoint appears to be performing normally. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com