Performance monitoring and Database Tuning of SQL Server - Reply to Topic
Close
Login to Your Account

Reply to Thread

Post a reply to the thread: Performance monitoring and Database Tuning of SQL Server

Your Message

Click here to log in

What is the latest version of LepideAuditor we launched? (like: 15.2)

 

You may choose an icon for your message from this list

Additional Options

Topic Review (Newest First)

  • 04-26-2013, 04:33 PM
    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/
  • 03-12-2013, 12:25 PM
    Bugsy
    Thanks Graham !

    Now I can differentiate & understand the both terms .
    Just is the software Lepide SQL Storage Manager do the both things ?
  • 02-21-2013, 07:02 AM
    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
  • 02-15-2013, 10:30 AM
    Bugsy

    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

Posting Permissions

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