Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqldbaa
Starting Member
32 Posts |
 Posted - 2012-01-22 : 22:56:52
|
| Hi Team,Can anyone help me out to how to proceed for a performance issue in SQL cluster server. A SQL Server have a very bad perfomance which is in cluster environment. Need to do a immediate analysis. But not familiar with the applications in the server, but was asked to find the problem as soon as possible. I would need plan of action, and process on what need to be checked and how to continue if not found any issue at first level. How to find things at high level along with assumptions and recommendations.Thanks in advance |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-23 : 04:47:07
|
| [url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/[/url][url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/[/url]Or hire a consultant.--Gail ShawSQL Server MVP |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-01-23 : 07:15:52
|
quote:
Or hire a consultant.
++It doesn't sound like you even know where to start looking, let alone what you are looking for.... This isn't a criticism, there are so many variables involved. It could be: Poorly written SQL Missing Indexes for well written SQL Misconfigured server settings Hardware issues..... .... .... .... .... Something else...Now you said:quote:
A SQL Server have a very bad perfomance which is in cluster environment.
Do you mean you have a few servers which all do the same job and only one of them is slow? Or did you mean something else.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
biswajitdas
Starting Member
44 Posts |
Posted - 2012-01-23 : 13:38:07
|
| WHERE YOU FACE THE PROBLEM IN THE CLUSTER , IS THE APPLICATION IS SLOW WHEN USER INTERACT TO IT.OR THE REPORTS ARE SLOW , OR ANY STORED PROCEDURE ARE TAKING LONG RUN.performances with Cluster server have lot of steps , can you tell me where exact the issue ?Sr Sql server DBA/Artitech |
|
|
|
|
|
|
|
|
SQL Performance question