Performance monitoring and Database Tuning of SQL Server 1885 https://lepide.com
Close
Login to Your Account
+ Reply to Thread
Results 1 to 4 of 4

Thread: Performance monitoring and Database Tuning of SQL Server

  1. #1
    Junior Member
    Join Date
    Jan 2013
    Posts
    8

    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

  2. #2
    Junior Member
    Join Date
    Feb 2013
    Posts
    8
    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.

  3. #3
    Junior Member
    Join Date
    Jan 2013
    Posts
    8
    Thanks Graham !

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

  4. #4
    Junior Member
    Join Date
    Feb 2013
    Posts
    8
    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/

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

Lepide® is a registered trademark of Lepide Software Private Limited. © Copyright 2018 Lepide Software Private Limited. All trademarks acknowledged.