The NY Metro SQL Server User Group will meet tonight at 6:00
Jim Guerrero of
Idera will examine best practices and techniques for monitoring performance and access to SQL Server including the following issues;
On the performance side we'll look at how you can use scripts, native tools and SQL diagnostic manager to use tried and true Ratios to identify problems. We'll also examine the use of Wait-Based events to pinpoint bottlenecks, as well as, how to determine who and what is hogging resources and slowing down your server, either in real-time or at some point in the past.
In regards to controlling access to SQL Server, Sarbanes-Oxley is on everybody’s mind. We'll see how SQL Server's native auditing utilities and Idera's new SQLsecure Auditor product will help you get a handle on who is accessing your system and what they are up to. We’ll show you how to define and document your controls. Plus, prove you are adhering to internal or external controls, and when your not, who the guilty parties are.
I'm on my way into the City now, so it's going to be a long day, hope to see you tonight!