Performance monitoring and Database Tuning of SQL Server

[Bugsy]

Hello

Can anybody explain whats is Performance monitoring?? Database Tuning??

both are the same thing ? or different
I am little confused

Thanks

[Sandhu]

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

[Bugsy]

Thanks Graham !

Now I can differentiate & understand the both terms .
Just is the software Lepide SQL Storage Manager do the both things ?

[Sandhu]

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/