|
|
|
Are You Prepared For A Hard Drive Crash?
Its just a matter of time before you experience a hard drive
problem. Are you prepared to loose your data? If your hard drive
crashed right now do you have an action plan to follow? Most
people only think of backing up their data after they...
Background Of Password Cracking
Passwords to access computer systems are usually stored, in some form, in a database in order for the system to perform password verification. To enhance the privacy of passwords, the stored password verification data is generally produced by...
Before You Take the Plunge: Essential Information on Data Recovery
Know what you're dealing with
The world of data recovery is a big mystery for most consumers
and even some IT professionals. This is largely because hard
drives themselves are complex devices and their technological
specifics are not...
Business Continuity and Disaster Recovery - Selecting A Business Continuity Strategy
The risk analysis and business impact analysis have identified risks to key business functions. Also, the potential impacts and probabilities of these risks as well as the costs to prevent or mitigate damages and the time to recover will have...
Getting More Bang for the Storage Buck
In an article titled "No Waiting: Considering the Benefits of Solid State Disks," 1 authors Ramon Sandoval and Maneesha Lee highlighted the growing popularity of solid state disks (SSDs) as accelerators for enterprise databases. The authors cited...
|
|
| |
|
|
|
|
|
|
Improving SQL Performance
How do you know how much hardware is really needed by your applications? And what do you do when your applications are overloading your system? The answer lies with improving your SQL performance. You have to tune your hardware SQL server and monitor performance, all of which will be explained as clearly as possible on this page.
The first thing to do when you want to improve your SQL performance is you need to learn how to optimize your system by finding out how much hardware you really need to run your applications. The best way to tune your hardware and monitor performance is through the art of performance monitoring which takes experience, knowledge, and sometimes even luck.
Performance monitoring guidelines:
Make sure you’re running your typical processes and work loads during the monitoring.
Don’t only do a real-time monitoring of your servers; capture long running logs.
Always have the disk counters turned ON.
Set up the chart windows with an interval of 18 seconds for routine, daily desktop monitoring.
Know the
Associated Websites
tools you are working with.
Don’t be afraid to experiment.
Know the terminology (“objects” are lists of individual stats available; “counter” is a single stat; “instance” is further breakdown of a counter stat into duplicate components).
A bottleneck happens when the hardware resources can’t keep up with the demands of the software. This is usually fixed in one of two ways: first, you identify the limiting hardware and increase its potential (i.e. a faster hard drive or increase the speed of the computer); second, make the software processes use the hardware more efficiently.
Five areas to watch when improving SQL performance and identifying bottlenecks:
Memory usage
CPU processor utilization
Disk input/output performance
User connections
Blocking locks
About the Author
Marisa Pellegrino is a freelance writer from Montreal and is the head researcher and content manager for SQL Server Database Recovery. www.sql-recovery.com
|
|
|
|
|
|