|
|
|
An Outsourcer’s Passage To India: How To Do It, Part I
Frankfurt airport departure lounge. Full of western tech executives, each with an open laptop. They're all from different companies, all travelling separately. But one particular subject is making them feel like they're old college buddies, and...
Business Continuity Testing starts with the risks
Business Continuity Testing starts with the risks
All business continuity analysis should be risk based, and risk prioritised to deal with the important business risks first. This means that any risks to your business need to be identified,...
Computer Disposal - Throwing Away Your Computer, Money, and Idenity
You may reprint or publish this article free of charge as long as the bylines are included. Original URL (The Web version of the article) ------------ href="http://www.defendingthenet.com/Newsletters/Throwing...
Data Backups - One Key to Business Survival
Your customer data is a precious resource that can literally be worth its weight in gold! If used properly, it can be repeatedly mined for additional sales and referrals. Do you use this gold mine to increase the profitability of your business? ...
Easy Guide to RAID Recovery
What is RAID RECOVERY? RAID stands for Redundant Array of Inexpensive Disks. It is a method of combining several hard drives into one unit. This method offers fault tolerance (the ability of a system to continue to perform functions even when...
Health and Medical Advice on the Internet: Use it Wisely to Overcome Illness and Find More Happiness in Your Life
I’ve got a bit of a problem with depression and anxiety. I’ve been tackling these problems for several years without the use of modern medicine. Tai Chi, meditation, martial arts (exercise), and positive interaction with other people...
...Identity Theft Recovery: The Road Back
Not too long ago, a friend of mine mentioned that one of his
coworkers recently recovered his stolen identity. I asked how
long the process took. "Only two years" he replied.
Compared to my business partner's six year nightmare "only"
maybe...
IT Department Skills to Support Microsoft Great Plains and Microsoft CRM
Microsoft Great Plains as ERP and Microsoft CRM as Client Relation Management system is very robust combination and could serve midsize to large corporation as Business System. Being VP IT or IT Director you need to foresee the positions to have...
Local Vs Remote Data Backup - The Pros And Cons
Backing up your data should be an essential part of your daily
routine. Unfortunately for many businesses this simply isn't the
case. The only time data backup crosses their mind is when they
have a hard disk crash or a serious spyware or virus...
Small Business Computer Security, the Basics
Anyone in business today realizes both the natural dependency on computers in the workplace, and also the potential dangers associated with storing important data on them. Today’s business owners are constantly being reminded that their...
|
|
| |
|
|
|
|
|
|
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
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
|
|
|
|
|
|