Tuesday, February 14, 2012

DBCC CHECKDB

Please Advice.
I run a SQL 2K SP3 on WIN 2K SP4 Advanced in an Active/Passive Cluster confi
guration.
I notice when I ran DBCC CHECKDB on one of my Production databases on the th
e primary node the available RAM Memory decreases command (DBCC CHCKDB) on t
he secondary node (same database) memory decreased slightly.
Please help.DBCC takes memory - so the SQL Server process takes memory from the system
on the primary node. It will not give the memory back until there is memory
pressure. This is perfectly normal. The secondary node has nothing to do
with the SQL Server process running on the primary node - something else
must be running on it.
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Timi" <anonymous@.discussions.microsoft.com> wrote in message
news:993FAEF2-A3FF-4D22-938E-055C6FD46372@.microsoft.com...
> Please Advice.
> I run a SQL 2K SP3 on WIN 2K SP4 Advanced in an Active/Passive Cluster
configuration.
> I notice when I ran DBCC CHECKDB on one of my Production databases on the
the primary node the available RAM Memory decreases command (DBCC CHCKDB) on
the secondary node (same database) memory decreased slightly.
> Please help.

No comments:

Post a Comment