|
Focus on: SQL Server Performance Monitoring & Diagnostics
Welcome to SQLsmarts, Idera’s newsletter for SQL Server Professionals!
We welcome your questions, comments or suggestions.
Email us at SQLsmartseditor@Idera.com.
|
In this issue:
|
 |
| Product News |
|
Announcing SQL diagnostic manager v4.0:
Real-time performance monitoring & deep diagnostics for SQL Server
SQL diagnostic manager provides industry-leading real-time performance monitoring, problem diagnosis, and correction. Wish you could pinpoint your “Worst Performing Procedures” or “Long Running Queries” in seconds? Wish you could see exactly what is happening on your SQL Servers right now, as well as three months ago? Then you need SQL diagnostic manager! It’s easy to use, provides centralized management, and requires very little system resources. Most importantly, it will save you hours of tedious administrative work and help you keep SQL Server running smoothly.
SQL diagnostic manager v4.0 offers even mor powerful enterprise-wide reporting and analytics – making it easier than ever before to build reports & analyze performance across your entire SQL Server environment.
New features in SQL diagnostic manager v4.0 include:
|
- Metrics Repository – Captures and stores SQL Server performance and availability metrics in a central repository from SQL Servers across the enterprise. Using data stored in the repository, DBAs can more easily analyze the SQL Server environment strategically for trend analysis, capacity planning, data comparison, data correlation, forecasting, and more.
- Best practice reports (pre-defined or customized) – Sample reports and a guide to writing custom reports are provided with SQL diagnostic manager v4.0. In addition, a new online community Web site allows SQL diagnostic manager customers to download pre-defined reports and to share their own best practice reports. Idera will continue to add reports as available.
- SNMP Alerting – Dispatch alerts directly to enterprise management frameworks like Tivoli, HP OpenView and CA UniCenter.
- Enhanced Web Console – Monitor SQL Server -- including SQL Server 2005 -- anytime, anywhere, in real-time from a simple Web browser.
|
|
Learn more about SQL diagnostic manager 
Try it FREE for 30 days!
|
|
|
| Case Study |
|
Idera Helps the California Department of Health Keep SQL Servers Running Strong
Mitch Bottel, DBA at the California Department of Health and his team are faced with the challenge of maintaining the 35+ SQL Servers that serve as the backend to several healthcare applications for the state. At any given time, these healthcare applications and data are needed by hospitals, state officials, congressmen and more around the state – for information ranging from healthcare to State Legislative bills. Mitch and his team rely on products from Idera to help them receive alerts faster, resolve issues more quickly and to save time and space backing up large databases.
Read the full story...
|
| Article |
|
“SQL Server Performance Boosters”
Author: Jeremy Kadlec, Edgewood Solutions
“SQL Server performance tuning is one job you'll never be done with; you won't be able to find that perfect performance configuration and keep it that way. You must continually identify and head off performance problems before they become bottlenecks for your entire organization. This article offers a list of FAQs that will help you address common performance-tuning issues for your SQL Servers.”
Read the full article >>
|
| Webcast |
|
Webcast: Understanding Indexes & Joins
Presented by: Stephen Wynkoop
SSWUG.org
February 8, 2006
In this webcast, you'll find out all the information you need to understand how indexes work, where you need them, how to determine the best use of them, how to maintain them and more. We'll also explain what JOINs are, how they're used and how you can put them to use in your applications immediately.
Register now >>
|
| Bryan’s Tips & Tricks |
|
SQL Server Checks
Here is a list of handy SQL Server metrics that you may have not checked lately. These helpful analysis reports will help you ensure that your SQL Servers are running effectively and efficiently.
(Tip: All of these reports can be run across your SQL Server enterprise quickly and easily with SQL diagnostic manager v4.0!)
|
- Processor/Physical Memory/Disk Subsystem: Are they adequate?
Analyze the ratio of CPU time to I/O time. If the CPU time exceeds the I/O time, the processor is relatively under-powered in relation to the amount of memory and the throughput of the disk subsystem. I/O time far exceeding CPU time indicates a lack of available physical memory and a poor disk subsystem in relation to the processor.
- How long are your users waiting?
Analyze the average number of lock requests per minute that could not be satisfied immediately and required the requestor to wait.
- Suspicious activity via unsuccessful login
Track all logins to your SQL Servers and pay special attention to unsuccessful logins as they may indicate potential or attempted security breaches.
- TempDB Objects – Are they sized correctly?
To analyze TempDB size, you should track the maximum size of the TempDB objects that are used during a selected period. This will tell you if the size of the TempDB should be set or left to dynamically grow and shrink.
- Need more memory?
Analyze the ratio between the maximum memory allocated to a SQL Server instance on a given day versus the portion actually used by the instance. This will help you create a more efficient environment and foresee potential performance problems.
- Need more memory in the SQL data cache?
Analyze SQL Server physical disk activity including the average physical reads and physical writes per minute made by SQL Server. A high level of physical reads indicates that you should consider allocating more memory to the SQL data cache to realize significant performance improvements.
(SQL diagnostic manager wil analyze lazy writer writes, page writes, page reads, checkpoint writes, log writes, and read-write errors.)
- Is packet size optimized?
Analyze the average number of network packets sent per minute to packets received. While you can do little about system activity, tuning packet size yields better network performance and increases throughput.
|
|
|
| Feedback |
|
We want to hear from you!
Do you have an interesting story about how Idera product(s) have helped you? Want to share a product tip, trick or hint?
Have product suggestions or questions?
Your feedback helps us ensure that our newsletter is helpful!
You may even find your input published here in future newsletters.
Please send your comments and suggestions to SQLsmartseditor@idera.com
|
|
|
|
Update Profile or Unsubscribe
