April 14, 2015 at 1:59 am
App is very slow...
What is the reason of it ? network , server or sql server ?
I should Check about sql server .
I use Performance monitor . To know the sql server is cause of the problem or not .
What counter I should check first and what is the standard values ? That I can say : No sql server is not cause or Yes it has problem.
thank you
April 14, 2015 at 4:05 am
You can start by reading this excellent ebook on the subject:
https://www.red-gate.com/community/books/accidental-dba
Troubleshooting is a complex topic, no single answer applies. Read the book and you'll find a detailed and simple troubleshooting methodology.
-- Gianluca Sartori
April 14, 2015 at 4:23 am
That book is absolutely the place to start.
Performance monitor is one of the tools you'll use to capture metrics. Those metrics are listed in the book. You're also going to want to look at the performance related Dynamic Management Views (DMVs), also listed in the book. One of the first to look at is sys.dm_os_wait_stats. That will show you which resources most of your processes are waiting on. That's one of the most important ways to start to troubleshoot performance issues.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply