Hoe to Monitor and troubleshoot Performance issues of resource bottlenecks and application bottlenecs

  • Hi, Iam new to this SQL SERVER DBA.

    Can any one give right approch to monitor, tune and troubleshoot performance issues at resource bottlenecks, application bottlenecs and also in SSIS & SSRS

    It might be simple for you, but please give me the right direction to follow and implement

  • That is honestly a huge topic. It's not one that you're going to get good guidance on from responses on a blog. As a starting point you could look at Gail Shaw's excellent articles over on Simple-Talk[/url]. Other than that, you should start reading books, attend professional training classes, or hire a consultant to get you started.

    When you have specific issues that need to be addressed that you can provide concrete examples, come back here and post them. You'll get good answers.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply