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.
| Author |
Topic |
|
adnanmehdi
Starting Member
1 Post |
 Posted - 2011-02-01 : 01:40:50
|
| I would like to know how to improve performance of SQL 2008. Previously it was sql 2005 installed as i upgraded i m facing different kind of problems listed below.1. Re-starting of server does not kill the suspended procedures.2. What is CXPACKET ?3. How can i monitor the performance of running procedures and hanged procedures.4. Is there any tool available to monitor the performance.I am presently helpless to what actions should be taken to get the optimized performance.Kindly suggest as early as possible.RegardsAD |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2011-02-01 : 10:40:45
|
| Did you rebuild all indexes after upgrade? What is server spec's for SQL 2008? CXPacket denotes that Query doesn't have proper index and parallelism with IO Issues. Check for the long running queries and Tune them. |
 |
|
|
|
|
|
SQL Process Monitoring and tuneup