Focus on SQL Server Index &
Table Defragmentation
Welcome to SQLsmarts, Idera’s monthly newsletter
for SQL Server Professionals! We welcome your questions,
comments or suggestions. Email us at SQLsmartseditor@Idera.com.
In this issue:
- SQL defrag manager now available!
- Could your SQL Server Indexes win an ugly contest?
Enter for your chance to win an Xbox 360!
- SQL Server Fragmentation: Is it affecting your SQL Servers’ performance?
- SQLsafe wins Editor’s Choice award for best SQL Server backup
and recovery
- Webcasts: “SQL Server 2008 – First Look” and more
|
|
| New from Idera: SQL defrag manager |
Idera SQL defrag manager now available!
Automate & optimize SQL Server defragmentation
The first and only product of it’s kind, SQL defrag manager continuously analyzes SQL Server fragmentation levels, pinpoints fragmentation hot spots, and intelligently defragments SQL Server tables and indexes automatically or on demand – providing improved and more consistent SQL Server database performance and response times.
Try SQL defrag manager for 14 days 
SQL defrag manager is a “must-see” for every SQL Server DBA!
|
- Improve SQL Server performance
- Automatically analyze index and table fragmentation levels
- Customize remediation with three easy options for defragmentation
- View fragmentation analysis in real-time and
- Manage defragmentation activity from a central console
- Generate comprehensive reports of analysis and activity
|
| |
What they’re saying about SQL defrag manager |
“One of the most difficult tasks in my day to day operations has been to maintain index optimization. SQL defrag manager allows me to configure automated index maintenance based on the fragmentation level of the individual indexes. The maintenance process runs each night, takes a fraction of the time it used to and has very little load impact. I find SQL defrag manager to be an indispensable tool in my day to day duties as a DBA.”
- Mike Flanagan, Senior DBA, Aries Systems Corporation |
|
| |
| Tech Tips |
SQL Server Fragmentation:
Is it affecting your SQL Server performance?
Over time, as data is inserted, updated, and deleted, databases become fragmented – a condition that consumes resources (such as disk, processor I/O) and adversely affects database performance, especially in large scale SQL Server environments. If left unchecked, performance can degrade to the point where SQL Server discards its indexes and uses slower, more resource intensive table scans to retrieve data.
Fragmentation ranks as one of the top causes of poor database performance, yet the task of defragmentation is often neglected because it can be extremely time-consuming, labor-intensive, and often must be done in off-hours to avoid service interruption.
Furthermore, one home-grown approach to defragmentation many not do the trick because different defragmentation methods are better for different indexes, based on the type of activity and load experienced by the database. Using the most lightweight approach across the board may not actually solve the issue for some databases, while using more aggressive “brute force” methods can result in unnecessary table and index locks.
More useful information:
|
| Awards |
SQLsafe wins SQL Server Magazine Editor’s Choice Gold award for best SQL Server backup and recover
 |
SQLsafe is a high-performance backup and recovery solution for Microsoft SQL Server that accelerates, encrypts and compresses database backups. SQLsafe speeds database backups by up to 50% and reduces disk space usage by up to 95%. SQLsafe also offers automated 'hands-free' multi-server backup management and monitoring and ensures compliance with corporate backup and recovery policies. SQLsafe was also recently recognized as one of the 2006 Products of the Year by SearchSQLServer and TechTarget. |
Find out more |
| Events |
LIVE WEBCAST:
SQL Server 2008 – First Look
Wednesday, August 22, 2007
4:00 PM Eastern | 3 PM Central | 2 PM Mountain | 1 PM Pacific
Hosted by: Microsoft, Edgewood Solutions & Idera
Space is limited!
Register now
Join us for an overview of Microsoft SQL Server 2008, code name "Katmai", the next generation of SQL Server. "Katmai" provides an enterprise data platform for your mission-critical applications, while providing a dynamic development environment and comprehensive business intelligence (BI) platform. We will discuss the key features available in the next version of SQL Server including exciting new additions like Change Data Capture, Table Valued Parameters, Declarative Management Framework, MERGE T-SQL statements, the new FILESTREAM attribute, Data compression (both for data and backups), Database Mirroring enhancements, Performance Studio, Spatial enhancements, Extended Event Tracing and handling, Entity Framework Model discussions, and much more.
About our presenter:
Chad Boyd, is an Advisory Support Engineer / Premier Engineer for SQL Server and Clustered systems with Microsoft Corporation. He is responsible for providing onsite and remote support, guidance, and advice with SQL Server products to some of Microsoft’s foremost enterprise customers running the largest, most complex SQL Server installations and configurations in the world. This includes all SQL Server products and versions, including SQL Server 7.0, 2000, and 2005. |
| 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
|
|
 |
|
|
|
|
|
|
|
|
|
|
|
|
|
____________________
____________________
CLICK HERE
Take the SQL defrag manager screenshot tour
|
|
|
____________________
Could your
SQL Server indexes
win an ugly contest?
Use Idera's SQL defrag manager to find out!
The top 3 most fragmented databases will win an Xbox 360!*
Here's how to play:
1) Download SQL defrag manager
2) Use SQL defrag manager
to analyze fragmentation across your databases
3) Take a screenshot of the SQL defrag manager output
for your database with the
most fragmented* indexes
4) Email the screenshot to uglyindex@idera.com for your chance to win an Xbox 360!
DOWNLOAD & ENTER
TO WIN NOW!
____________________ |
|
|
Visit Idera at these upcoming events:
____________________ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Update Profile Unsubscribe 
