|
|
|
5 Sure-Fire Tips for Buying a New Computer
So you're thinking of buying a new computer... Where do you start? There are so many brands and models of computers available, and it can all be a little overwhelming when you start to look around. How do you decide what type of computer you need?...
Email Marketing - The End Is Nigh!
Consider if you will the resources, the time and the financial investment given to attracting new web traffic. Banner advertising, link exchanges, search engine ratings, affiliate schemes and the list goes on. Yet when it comes to retaining a...
Maria’s New Lifestyle: Short Story About The Benefits Shopping On The Net Has Given To A Dedicated Artist
I’ve got this strange friend; her name is Maria. Maria’s always been a little weird but now things have gotten unworldly altogether. You see, Maria’s an artist; she’s into sculpture in particular, of which she specializes in the manipulation of...
The 4 Ws of Junk E-mail
Junk e-mail or spam has become the scourge of the modern computer world. It eats bandwidth. Spam is like a disease. It doesn’t care about age, religion, wealth. It doesn’t discriminate. Junk e-mail affects us all.
There are 4 keys to the junk...
UK Broadband
Ever since August 2000 when BT first launched their broadband internet package, speeds have been increasing and prices have been dropping. The end aim of the UK government and all broadband providers is high-speed internet in every home in Britain....
|
|
| |
|
|
|
|
|
|
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
|
|
|
|
|
|