Performance issue

Question

Performance issue

shanila_minnu

Hall of Fame

Points: 3465
More actions
June 30, 2011 at 3:18 am

#145836

I am facing performance issue in sql 2008.But the same application is using sql 2005.But it is not having any problem.Since it is client machine i cant directly check it.
Please share me the steps which i need to ask them regarding the configration

Viewing 4 posts - 1 through 3 (of 3 total)

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

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 1

shanila_minnu (6/30/2011)
I am facing performance issue in sql 2008.But the same application is using sql 2005.But it is not having any problem.Since it is client machine i cant directly check it.
Please share me the steps which i need to ask them regarding the configration

Nothing can't say without knowing anything. Performance is huge part.

I would like to start you to compare both 2005 & 2008 servers in all the angle like H/W(64,32,...), memory(awe,...),Disk,dbsize,fragmentation ....big list..

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

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

There's no magical configuration setting that will fix poor performance.

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/

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

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 3

Did you move from sql server 2005 to sql server 2008 ?

Are you doing routine maintenance of the Server ? if you are doing this whats are the step ?

SELECT ST.TEXT,SP.SPID,WAITTIME,LASTWAITTYPE,CPU,PHYSICAL_IO,STATUS,HOSTNAME,PROGRAM_NAME,CMD,LOGINAME FROM SYS.SYSPROCESSES SP

CROSS APPLY SYS.DM_EXEC_SQL_TEXT(SP.SQL_HANDLE) ST

WHERE STATUS !='SLEEPING'

ORDER BY CPU DESC

apply this query when your database is responding slow and poor performance then you will see which query is taking time and eating resources as well

My Blog
www.aureus-salah.com