Posts
Sort by recent activity
2.3.0.334 Error: Blocked Process stays Active if "Unknown"
Blocked process: SQBCoreService.exe
Process ID: 152
Database: xcp_trans
Host: 307997-DB1
User: IAD\935960-sqlsvc
Start time: 12:08 AM
SQL fragment: BACKUP LOG [xcp_trans] TO VIRTUAL_...
2.3.0.334 Error: JSON serialization
/TopQueries/AlertDetails?channelInstanceRef=7%3ACluster%2C1%2C4%3AName%2Cs31%3A308186-ntclus.iad.intensive.int%2C9%3ASqlServer%2C1%2C4%3AName%2Cs0%3A%2C&date=10%2F24%2F2011%2009%3A51%3A47: 500 err...
2.2.1.23 Duplicate PK definition - SSC Inoperable on this DB
Committed major architectural change on Monday, involving a table that used to be in DB Rpt and was replaced by a table of the same name and same PK name in DB Trans - this meant ZERO code changes ...
6.5 VDI problems seem more frequent
Having noted the
Improved timeout for VDI functions and threaded SQL connections
point in the release notes, I installed the update immediately as I've had about 3 or 4 VDI-related "failures" pe...
2.2 Monitoring Stopped - Hosted Environment - Need Fix
We operate in a Rackspace hosted environment with 2 boxes: the SQL Cluster we're monitoring and a VM that hosts SQL Monitor (as it can't live on the cluster). Rackspace is a highly shared infrastr...
2.2.0.260 - misleading or bogus "ended" Job Duration Alert
Job runs hourly and has a typical duration of under 20 seconds. Having just rewritten the underlying SP and added additional data points to evaluate, the job now runs between 1:35 and 2:26. The l...
5.0.1.7 Smart Rename creates incorrect script
Renaming a table that is only used in a trigger that posts updates to a same-named table in another, audit, database generates the change script without reference to the audit database and doesn't ...
2.0 - Cannot download for overnight install
http://www.red-gate.com/supportcenter/Content?p=SQL%20Source%20Control&c=all_products%5carticles%5cLicensing_%26_Activation_resources.htm does not include SQL Source Control, so, per policy here, I...
2.2 - Bogus "Log backup overdue" messages
2/18: Installed 2.2 - upgraded from 2.1.
2/20: Firewall reconfigured by ISP, which knocked out SQL Monitor.
2/22: raft of "Log backup overdue" messages emitted for all "Full" Recovery Mode DBs at t...
Monitoring Stopped - NOT INFORMED OF THIS
If Monitoring STOPS, kindly send me a "REALLY OBVIOUS EMAIL" that states this has happened. "All quiet" doesn't mean my servers are OK, they may be subject to the painfully frequently occurring "I...