January 28, 2011 at 1:54 pm
The only errors in the System Event Log are this:
Replication-Replication Distribution Subsystem: agent GODZILLA-XFDprod-XFDprodPub-XFD-BK-PDC-22 failed. The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.
occurring every minute or so.
Granted, we really ought to get that fixed (it seems unrelated, but maybe it's the cause?). But does this occurrence, at this frequency, eventually bring SQL Server down to its knees and stop responding to requests initiated by our web app on IIS
Both are running on Server 2008 R2.
I also tried to run Mgmt Studio to check for runaway processes, SPIDs, or pool issues, but it wouldn't even run...it got hung up at the Splash Screen.
The only way to get it back up was to reboot the server.
Any clues? Much appreciated!!!
Thanks!!!
January 28, 2011 at 4:17 pm
subcription expires by default. your replication setup script should make it never expire.
see: if_PostLink('http://www.sqlservercentral.com/Forums/FindPost164673.aspx')
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.
January 28, 2011 at 10:49 pm
Is SQL Server the only application installed on the server or is it sharing resources with other applications? Does the performance degrade at the exact same time, or when some type of common activity occurs like a bi-weekly report, or scheduled job?
When performance degrades can you open task manager to see if CPU is pegged, or out of memory? Or see what exe is using lots of resources?
If you can open SSMS and have the dedicated admin connection enabled you might be able to connect and see what SPIDs are doing at that time.
You might try setting up a remote perfmon trace to collect some data but that will consume some resources so you will want to target key counters.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply