| Focus
on: Portable SQL Server management
and administration
Welcome to SQLsmarts, Idera’s monthly newsletter
for SQL Server Professionals! We welcome your questions,
comments or suggestions.
Email us at SQLsmartseditor@Idera.com.
|
| |
| Product
News |
Have
you heard about Idera SQL mobile manager?
Monitor
& Manage SQL Servers from your PDA or Windows Mobile Device
Now with enhanced security features
Idera has added a new power-charged product to our line of
tools for SQL Server Superheroes—SQL mobile manager.
Now you can monitor and manage databases anytime, anywhere
using a Windows Mobile Device. Imagine having all of the real-time
SQL Server performance metrics, diagnostics, alerts, and management
information you need in the palm of your hand! Or imagine
using your stylus like a magic wand to fix nagging SQL Server
hang-ups in just minutes!
|
SQL mobile manager allows you to perform amazing
array SQL Server management feats from your Windows Mobile
Device including:
- Receive immediate notification of SQL Server issues
via customized alerts
- Configure alerts around critical issues such as CPU
utilization, database growth, network traffic, long
running jobs, failed jobs, blocking processes, stopped
services, and more
- Monitor SQL Server statistics or metrics at a glance.
- Track users, processes, batches, transactions, CPU/memory
utilization, network traffic, disk I/O, and more --
in real-time or over-time
- Start or stop a job, agent, or service or reboot a
server
- Track SQL Server agent and job status
- View database and operating system event logs
- Check SQL Server hardware and software configurations
- Execute TSQL commands and batches
What’s more, SQL mobile manager installs in minutes
and you don’t have to be a SQL Server expert to
use the product. It even provides easy-to-understand advice
that will help you reduce bottlenecks and improve performance
across your entire SQL Server infrastructure.
|
Just
Announced: SQL mobile manager version 2.4 offers enhanced
security features and more |
Security Enhancements:
- Stronger password enforcement & timeout options
- Limit access to a specific person on a specific mobile
device
- Restrict access and permissions by user
- Force turn off of potential security holes such as
Bluetooth
- Keep an audit trail of all security events
Security Enhancements:
- View the status of all servers at a glance from a
single screen
- Instantly identify servers that are in trouble and
why
- Create customizable views with your most critical
servers
- Drill down for deep diagnostics or to take action
Job Steps:
- Add, edit, delete job steps
- Start jobs from any job step
|
Find
out more about SQLmobile manager version 2.4! 
Try SQL mobile manager free for 14 days!
|
| Real-life
User Stories |
|
Plexus
uses SQL mobile manager to ensure SQL Servers run smoothly—anytime,
anywhere
Mr. Tom Lane is the database manager at Plexus, the leading
custom electronic design, development, and manufacturing service
provider. It’s Tom’s job to ensure Plexus’
30+ SQL Server databases, distributed worldwide, run smoothly
and as planned. Mr. Lane chose Idera’s SQL mobile manager
to help him monitor, manage and control SQL Servers –
using only A WINDOWS MOBILE DEVICE.
“Because our SQL Servers are distributed worldwide,
literally thousands of things can go wrong with them at any
time of the day,” said Tom Lane, Senior Database Manager,
Plexus. “My challenge is the 3-hour commute I have to
the office. While on the road, I am powerless to fix anything,
so I would often arrive at work with an inbox full of voice
mails and emails asking for help. SQL mobile manager keeps
tabs on our SQL Servers 24 x 7 alerts me immediately if there
is a problem. Then, if necessary, I can take action to fix
the problem right from the palm of my hand – even if
I’m on the road or away from my desk. It has
a lot of power for such a compact product. And it’s
easy to use. It has made my life much easier!” |
| Tech
Tips |
Tips
for Using Performance Monitor
SQL Server Performance.com
Window's Performance Monitor allows you to monitor what is
going on with a SQL Server and provides the basic information
needed in order to tune a SQL Server properly. Because Windows
Performance Monitor can create considerable overhead on your
server, you should use it only on key servers and limit the
number of Performance Monitor Counters you deploy. This article
will teach you more about how to use Performance Monitor and
will provide a list of recommended performance monitor counters.
Read
the full article
|
| Webcast |
Check
Out These New
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
Register Now
|
|
|
“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
|
| 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
|
|
 |
|
|
|
|
|
|
|
|
|
|
Quickly
analyze SQL Server metrics in graphical form. Shown here,
memory allocation:
VIEW DETAILED IMAGE
|
|
|
|
|
|
View
the detailed information about all SQL Servers in your environment
from a single screen:
VIEW DETAILED IMAGE |
|
|
|
|
|
Visit Idera at these upcoming events:
|
|
|
|
|
|
|
|
|
|
|
|
Update Profile
Unsubscribe
