[dba-SQLServer] SQL Cluster

Martin Reid mwp.reid at qub.ac.uk
Wed May 7 14:14:42 CDT 2014


Jim
Just shots of monitoring

martin

Sent from Windows Mail

From: Jim Lawrence<mailto:accessd at shaw.ca>
Sent: ‎Wednesday‎, ‎7‎ ‎May‎ ‎2014 ‎17‎:‎19
To: Discussion concerning MS SQL Server<mailto:dba-sqlserver at databaseadvisors.com>

Hi Martin:

The screen shots are not linked. Are they important to the message?

Jim

----- Original Message -----
From: "Martin Reid" <mwp.reid at qub.ac.uk>
To: "Discussion concerning MS SQL Server (dba-sqlserver at databaseadvisors.com)" <dba-sqlserver at databaseadvisors.com>, "Discussion of Hardware and Software issues (dba-tech at databaseadvisors.com)" <dba-tech at databaseadvisors.com>
Sent: Wednesday, May 7, 2014 6:33:39 AM
Subject: [dba-SQLServer] SQL Cluster

See below from one of my colleagues. Anyone have any comments/advise/ideas?

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

The 2 screenshots show my findings:

[cid:image004.png at 01CF6A01.568B1220]

[cid:image005.png at 01CF6A01.568B1220]

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

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



More information about the dba-SQLServer mailing list