Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Monitor Server Expand / Collapse
Author
Message
Posted Wednesday, April 13, 2005 1:15 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 16, 2008 4:19 PM
Points: 110, Visits: 17
With SOX in place, can a developer atleast "monitor" a questionable server? I have been trying to fix a deadlock issue on a production server for two days with this "Hands off" approach....and may have fixed it. But I need to monitor the server in question.
Post #174523
Posted Thursday, April 14, 2005 3:31 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 1, 2011 2:15 AM
Points: 278, Visits: 303

Yes....by thinking outside the box and running with a solution whereby "you monitor under intense supervision" from your production support team.  SOX doesn't say "Developers can't have ANY access to Production".  Sox says "You should put firm documented policies and procedures in place to ensure adherence to good practice (both IT + Operational) - re seperation of duties in normal operations.  And to ensure reasonable, documented and supervised policies and procedures re access, etc exist to handle unusual out-of-course operations".  Once the access to production is logged and monitored, then compliance with SOX is inbuilt.

Alternatively you backup your database to another server, and periodically re-apply the production transaction logs on the backup server (step by step debug style), when you encounter a deadlock problem.  It might not equate to active monitoring, but at least you can come close.

One other way to your objective is to create (buy) and deploy a health-check appliction, which monitors KPI's of the database...ie throughput, average i/o, problem queries, etc....and let it do the monitoring for you.




Post #174660
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse