November 3, 2015 at 7:11 pm
Can anyone teach me how to monitor the performance of the Database?
I knew we can monitor through Activity Monitor but the information given is too less.
I want to monitor the performance before I create the Sql Audit trail and after. I knew create Sql Audit trail will decrease the performance of database but where to study?
November 5, 2015 at 4:42 pm
September 23, 2016 at 12:01 am
This was removed by the editor as SPAM
September 23, 2016 at 10:02 am
For more full monitoring, Red Gate, SQL Sentry and others have products that will do it. They monitor a whole lot more than just performance. They aren't free, but they include an awful lot of stuff you might not think of.
When it comes down to fixing things, I haven't seen anything beat an old-fashioned review and fix of the bad code. The monitoring will help you find it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply