Post a reply to the thread: Monitoring load on capacity of the SQL server
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
glad to help ! freely ask SQL related questions here we are here to help you round the clock
Many Thanks for clearing my doubts about performance threads in SQL server
Thanks john ....Storing data non-contiguously on disk and having many truncation in your database, resulted your database has occur fragmentation. In other word we can say your database performance is decrease to avoid this you should perform these operations 1.Defragmentation 2. Rebuilding the indexes 3. Reorganising the indexes 4. Shrink Database (If needed) 5. Partition Table/Indexes 6. Reallocate page in logical order by heap method Pankaj
Great info So how can be overcome these issues ??
DBA responsible for maintaining SQL server and its database but, as the volume of data has grown and the load on the server increased, the queries have grown slower and deadlocks have become a frequent occurrence. so these are some main points that may responsible for performance degradation in SQL Server 1. Retrieving too much data. 2. Misuse of transactions. 3. Misuse of indexes. 4. Mixing OLTP, OLAP, and reporting workloads. 5. Inefficient Index 6. Join operations or inefficient join operations 7. Using an inefficient disk subsystem.
Thanks Pankaj Can we monitor what is actually causing our SQL server performance how can we limit on that thanks john
Hi JohnMat You can monitor the system performance by using the Performance monitor console and its related counters in Windows 2000. These counters allow you to view or save information about the overall performance of your server. When you install Microsoft SQL Server, additional Performance monitor objects and counters are automatically installed. You must have administrative access to your SQL Server to use these objects, SQL Server Admins should find them invaluable in monitoring and tuning the database server. To open the Performance monitor in Win2K, go to Start | Programs | Administrative Tools | Performance. When viewing your performance data in real time, you can view it as a report, a chart, or a histogram Attachment 12
Monitoring load on capacity of the SQL server Hi, How to monitor the capacity load of an SQL server? Is this possible with native SQL server Management, I am specifically interested in finding out how database is slowing down and causing poor performance of SQL server. Thanks
Monitoring load on capacity of the SQL server
Forum Rules