-
Performance monitoring and Database Tuning of SQL Server
Hello
Can anybody explain whats is Performance monitoring?? Database Tuning??
both are the same thing ? or different
I am little confused
Thanks
-
Hi Sachin
Monitoring is basically collecting information about the server.
In terms of performance monitoring, you're collecting the type of information directly related to performance such as how much memory is in use, how many and what kind of wait states are occurring, how long are the various queues on the system, how long are the queries taking to run, etc.
Tuning is then applying the information gathered through monitoring to make adjustments to code, indexes, structure, or infrastructure, in order to eliminate
the pain points identified by the monitoring.
Hope it helps you to understand the both terms
Last edited by Piyush; 02-21-2013 at 07:07 AM.
-
Thanks Graham !
Now I can differentiate & understand the both terms .
Just is the software Lepide SQL Storage Manager do the both things ?
-
Yes, Lepide SQL Storage Manager perform both things
It monitor and manages SQL Server's Capacity as well as perform operations like De fragmentation, Shrinking, Rebuilding the indexes, Partitioning and many more for database tuning which in turn improve the overall performance of the SQL Server.
Give it a try to manage your SQL Server check it from here also
http://www.lepide.com/sql-storage-manager/
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
Forum Rules