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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL Performance question

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 Shaw
SQL Server MVP
Go to Top of Page

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 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -