Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Monitor Server


Monitor Server

Author
Message
Martin D. Cymerman
Martin D. Cymerman
SSC-Enthusiastic
SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)

Group: General Forum Members
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.
AndrewMurphy
AndrewMurphy
SSC Veteran
SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)

Group: General Forum Members
Points: 280 Visits: 304

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.





Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search