April 6, 2012 at 1:36 am
Hi,
I want to know what issues will come in to picture on Performance point of view in general.
like long running queries, slow table access etc....
You people have you faced any issues in this scenario of performance. please let me know what kind of issues you faced and solved.
Because of I also going to handle the servers and be alert for performance issues.
Thanks in advance
April 6, 2012 at 1:57 am
running query slow rather than expected time .this type of issues will comes under performence issues ,and etc
April 6, 2012 at 2:34 am
Your question can't be answered in a forum post.
Especially the term "in general" could be broken down into the following subsections:
Hardware (e.g. slow spindles, network issues,...)
Overutilization of hardware (heavy load on CPU and/or I/O by other applications running on the same server)
Inefficient database design (lack of normalization)
Missing/incomplete/inefficient indexing
and the most common: inefficient code.
There are several books written about each subject.
You could "solve" (or at least postpone) performance issues by throwing bigger hardware into the game. But then you could also start working for that company located Walldorf, Germany....
April 6, 2012 at 4:15 am
I've got a 600 page answer for you. It's the book down in my signature on Query Performance Tuning. Performance monitoring and tuning is a HUGE topic.
Another book you should take a look at is Troubleshooting SQL Server Performance[/url] by Jonathan Kehayias & Ted Krueger. It's a great read. You can download the e-book for free.
"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 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply