While working with the large SQL Server Databases the most common issue that user(s) or administrator(s) face is the Performance issue, which eventually results in the sluggish response to the queries, thus delaying the application response time.
Performance refers to the way system behaves in response to a particular query. Performance is measured in terms of system response time, throughput, and resource utilization. With the performance issues in Database, usually user(s) or administrator(s) faces delayed response with the application resulting in increased cost-to-company.
Performance issue can be caused due to more than expected usage of available resources like CPU, memory, data-disk and network etc. It is also caused by SQL instance level performance counter(s) like buffer pool, access methods etc., SQL instance level DMV info like top ‘n’ database(s), top ‘n’ wait stats and top ‘n’ queries.
Apart from the above mentioned resources and counters, there are other factors which causes the irregularity in data and log file growth, thus resulting in degradation of performance for SQL Server.
To rectify the above issues, Performance Tuning is an essential and key aspect to get the Database and SQL Server running in an optimized manner.