Further info:
After running the following script, I found that the master and model dbs contained 22,000,000 each. Also, when applying the script to other SQL 2005 servers, the exact same results were obtained. When I ran it on SQL 2000 servers, they returened a zero (0). Is this inherent to 2005? Is this taking up space? Can I get rid of it? Will this be problem in the future if I want to start actual replication? Just some things that keep me awake at night....
SELECT
CAST(RTRIM(INSTANCE_NAME) AS VARCHAR(15)) as [database],
CAST(RTRIM(COUNTER_NAME) AS VARCHAR(31))as [Counter],
CAST(RTRIM(CNTR_VALUE) AS VARCHAR(10)) as [Value]
FROM MASTER..SYSPERFINFO
WHERE [Counter_Name] like '%XActs%'
|||
Probably a perfmon bug of some sort, not replication. master and model cannot be replicated anyways.
|||Please excuse this intrusion. Have you learned any more about this issue? We've encountered the same problem; replication is not being used but a HUGE value for that counter.
Thank you for your time.
Bill
No comments:
Post a Comment