database performain slow

Question

database performain slow

shiv-356842

SSCarpal Tunnel

Points: 4309
More actions
September 28, 2007 at 8:54 am

#181523

HI Friends,
My database performing slow.
In which area i will take care.
Can u any body plz explaine me step by step plz
Thsx
siva

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 734564 More actions · Answer 1

This is such and open ended question. If you can't narrow down what is slow, it's hard for us to help you.

First, define slow. How do you know it's slow. What "symptoms" lead you to believe it's slow. How does that compare to what you expect?

Then, what have you checked? Have you looked at any resource usage? Any performance monitors?

SQL_ABD SSCertifiable Points: 5832 More actions · Answer 2

Before I will do some tests to see if the real problem is the database, by taking some queries and check the processing time.

For me I will create a test environment (database + application), then run the profiler to detect queries which take a long time to run.

You can first proceed by tracing small functionality then take the trace in the query anlyzer then perform (Index Tuning Wizard) to create the recommended indexes.

Then you have to check in the profiler, for more details.

Ahmed

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 3

Siva, based on your post I will venture that you have little to now experience or training in tuning a sql server database system. Do yourself and your company a favor and hire a professional to give you a quick performance review. A day or two could almost certainly provide you with an incredible wealth of areas to improve upon!!

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

anton de lange Grasshopper Points: 18 More actions · Answer 4

Hi, my name is Anton. If i wanted to hire a professional to review our Company's SQL server performance, where would I get contact details?. I'm in South-Africa. My knoweldge of SQL Server 2005 is very limited.

We run Windows 2003 Std with SQL 2005 (With a Main and Admin Website on the same server as the SQL). The pages open fast but some of the queries tend to take some time executing.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Anton, see the PM I sent you.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

anton de lange Grasshopper Points: 18 More actions · Answer 6

Thanks for all the help, i will contact him and make an arrangement.

Anton