help!!!!!help!!! how can i tune

Question

help!!!!!help!!! how can i tune

Ponguru.SreenivasaRao

Right there with Babe

Points: 778
More actions
February 2, 2005 at 8:58 am

#109489

hi all
i have server with 1GB ram,dual processor,
36*4 HDD
and i having 12gb data,my application running very very slow
every day we doing around 1000 transaction
that transaction we entering throu application and some of transaction thru flat files
what r the steps i suppose check
what r thing i suppose do

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

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

Goce Smilevski SSCommitted Points: 1704 More actions · Answer 1

Hi,

the usual rule of thumb is to first solve the problem that is causing the most of the problems. So, start the SQL Monitor and observe the execution of SQL statements that application sents to the server. Pay attention on those parts of the application with worst performance. In the duration column of the trace you can see the time spent by the server to execute the statement. But, the cause for problems is not always the database server itself, since there are many factors here (the network, for example).

Regards,

Goce.

Antares686 SSC Guru Points: 125444 More actions · Answer 2

Also what maintainence are you doing regularly on the database. And I believe Goce was refering to SQL Profiler in the comments previous.

barsuk SSChampion Points: 12280 More actions · Answer 3

run sp_who2; and see if there is blocking or old connection....

Bimal Fernando SSCommitted Points: 1945 More actions · Answer 4

You may need proper indexing of the tables, and possibly defragmenting existing indexes because you have abuot 1000 transactions changing the database every day.

http://www.sql-server-performance.com/rd_index_fragmentation.asp

When you say your application is slow, is it when your modify data or retrieve data ?

if it's retrieval check your queries to see if they query very large tables and check the indexes on those tables.

http://www.sql-server-performance.com/nb_execution_plan_statistics.asp

is your storage system under any RAID Array?

Check the Disk Activity with windows performance counter (Physical Diskisk Queue lenth) to see if there is any contention on the disks.

http://www.sql-server-performance.com/sg_sql_server_performance_article.asp

good luck...

threegs39 SSChasing Mays Points: 623 More actions · Answer 5

Another tool to use is the index tuning wizard, if you know which tables are causing the performance issue. This is good to use in conjunction with profiler.