Comp

• Database management system - supports different techniques in tuning database performance
• Partitioning - means breaking the database into several multiple files
• Indexing - determines proper indexes or keys for each table
• Normalization - identifies the proper table for table querying
• Clustering - enforce the physical sequences of a table for faster SQL execution
• Multiple table into one - combines or forms table into one new table
• Free table - leaves room for any data expansion
• Data compression,- reduce the number of requirements present in one storage
• File placement and allocation - puts the right file in its proper location
• Page size - determined proper page size for efficient data storage
• Data reorganization - realigns database objects to prevent possible performance degretion
• SQL Server Management studio - monitors the performance by means of a performance manager
• Overview - shows the graphical display of processor time(%)
• Processor - show the list of active user which are connected to the SQL Server Database Engine
• Resources waits - provides wait information such as memory, CPU, allocation, network management, and other resources
• Data file 1/0 - holds the disk info related to the data and the log files of user and system database
• Recent Expensive Quarries - display all the info regarding quarries especially the most expensive quarries
• Overview Pane - allows you to see how the instance is performing. It shows a graphical representation of each process you under take within the server
• % Processor Time - knows as the elapsed time hack the processors I/0 or memory
• Waiting Task - shows the number of waiting task for processor 1/0 or memory
• Database I/O - shows the transfer rate in MB/SEC from memory to allocation
• Batch Request/See - shows the number of SQL Server which receive instance by batches
• Refreshed Interval - configuration the refresh rate interval of activities done in SQL
• Pause - stops the activity monitor
• Refresh - obtains automatic updates before on interval takes place
• Processor Pane -shows the user details connected in the database server. Its also called activity monitoring