SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL Performance question
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sqldbaa
Starting Member

India
32 Posts

Posted - 01/22/2012 :  22:56:52  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 01/23/2012 :  04:47:07  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Or hire a consultant.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Transact Charlie
Flowing Fount of Yak Knowledge

United Kingdom
3451 Posts

Posted - 01/23/2012 :  07:15:52  Show Profile  Visit Transact Charlie's Homepage  Reply with Quote
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

USA
44 Posts

Posted - 01/23/2012 :  13:38:07  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000