| Focus
on: New Products
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: |
 |
| Product
News |
Just
Announced: SQLscaler
Load & Stress-testing for Migration &
Consolidation Planning
SQLscaler, version 1.1, is a powerful new load-testing solution
for predicting the behavior and performance of SQL Server
databases under stress. SQLscaler will help you plan for changes
in your SQL Server environment and will help you ensure the
success of key projects such as SQL Server 2005 migration,
server consolidation, application roll outs or upgrades, and
new hardware implementations.
Developed in partnership with Scalability Experts,
leading practitioners in SQL Server infrastructure design
and scalability, SQLscaler provides an integrated suite
of software tools, built-in knowledge, and pre-defined reports
that will allow you to:
|
- Create and inflate test databases using specified
parameters or intelligent algorithms based on metrics
from an existing production environment
- Create scripts and automate test-case execution to
simulate a real-world SQL Server environment
- Create reports or use pre-defined reports to perform
comprehensive analyses of test results. All test result
data is stored in a central repository
|
|
Planning to migrate to
SQL Server 2005? SQLscaler will help you compare
performance and scalability measures by running a stress test
against SQL Server 2000 and then against SQL Server 2005.
Click to View
Find out more about SQLscaler version 1.10 
Try SQLscaler free for 30 days!
|
|
Just
Announced: SQL mobile manager
Monitor & Manage SQL Servers from
PDA or Cell phone
SQL mobile manager version 2.3 enables database administrators
to securely monitor and manage SQL Servers anytime, anywhere
using a Windows Mobile Device such as a cell phone or a PDA.
Imagine having real-time access to a comprehensive
set of performance metrics, diagnostics, alerts, management
information and administrative actions all from a PDA or
other Windows Mobile Device! SQL mobile manager provides: |
- Real-time and historical performance metrics such
as users, processes, batches, transactions, CPU and
memory utilization, network traffic, disk I/O and more
- SQL Server agent and job status
- SQL Server and operating system event log content
- Alerts, fully configurable, for items such as CPU
utilization, database growth, paging, network traffic,
long-running jobs, failed jobs, blocking processes and
stopped services
- Tuning guidelines for reducing bottlenecks and improving
performance
- SQL Server hardware and software configuration
- Executing TSQL commands and batches
- Start and stop a job, agent or service or reboot
a server
|
|
Click to View
Find
out more about SQL mobile manager!
Try SQL mobile manager free for 30 days!
|
| Events |
Live Webcast
Strategic Planning in your SQL Server Environment:
Capacity Planning, Trend Analysis
Presented by: Stephen Wynkoop
SQL Server Worldwide Users Group
May 17, 2006
This webcast will help you better understand how to build
a forward-looking plan to address your overall system growth.
Find out about capacity planning, trending tools, usage analysis
and much more in this webcast. You'll also learn how to use
the tools that are native to the SQL Server environment -
tools that can help you when planning for database growth,
disk utilization planning, and much more.
Register Now
|
|
|
On-Demand Webcasts
Top 10 Tips for a Successful Migration to SQL Server 2005
Presented by: Scalability Experts & Idera
View this webcast at your convenience to learn:
- The top 10 essential migration tips that will help you
avoid potential pitfalls and costly mistakes when upgrading
your SQL database environment to SQL Server 2005
- How to analyze existing resources and stress-test your
environment to predict problems before they happen
- New features and utilities offered in SQL Server 2005
designed to ease the upgrade process
View the Webcast
SQL Server Performance Myths
Presented by: Jeremy Kadlec
Edgewood Solutions
View this webcast at your convenience to learn:
- The impact of an incorrectly designed database and poorly
written T-SQL
- Various SQL Server performance tuning worst practices
and how to resolve them
- SQL Server 2005 SQLOS and Dynamic Management Views for
performance tuning
View the Webcast
|
|
|
|
|
|
|
Try SQLscaler!
DOWNLOAD NOW!
 |
|
|
|
|
|
Try SQL mobile
manager!
DOWNLOAD NOW!
|
|
|
|
|
|
Live Webcast May 17:
Capacity Planning &
Trend Analysis
REGISTER NOW!
|
|
|
|
|
|
|
Testing
your servers |
| for real performance is more than just
running select * from your tables and making sure information
is returned. You need to unleash the user community and
have them beat on your servers to make sure they can respond
like you need them to. Short of going out and bribing
your users to sit and test your systems in a controlled
environment, how do you do this? Check out SQL Scaler.
This utility will work to really give your servers a work
out and will give you real information that you can use
to tune |
| and
tweak your systems. |
| — Stephen Wynkoop
Microsoft MVP
www.SSWUG.org
|
|
SQL
mobile manager |
| provides my team with flexibility, convenience,
and the ability to act quickly to ensure that our SQL
Servers perform without hiccups. We really like being
able to monitor our servers from anywhere 24 x 7. And
with the instant alerts, monitoring, diagnostic details,
and management features that SQL mobile manager provides,
we can diagnose and correct SQL Server problems before
users even notice — |
| all
from a mobile device! |
| — David Bentz
Development Manager
Sears Home Improvement
Products
|
Visit Idera at:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
