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 |
|
tappers
Starting Member
2 Posts |
 Posted - 2010-12-08 : 05:48:19
|
| Only started using SQL Server 8 months ago and not done a lot since then but am trying to learn more!I work for a company that writes their own software (1 application mainly) but they also use another both sitting on SQL Server.The server has recently been replaced and a new network and we are still experiencing calls about very slow perofrmance.I would like to check SQL to check there is nothing that is causing the problems but don't know where to start.Could anyone give me some pointers?Thanks |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-08 : 05:55:23
|
| First think to do is find out what is meant by slow performance. All the time or occassionally, everything or just a few actions.It's usually just a couple of things causing an issue which may be having a know on effect.Identify and optimise those (which may mean restructuring the database/application) and the problem goes away.Ask the users and you may be able to identify queries that cause an issue.Otherwise trace what is happening on the server - if you have access via stored procedures then this is simple - just log the satrt and end. If you've made the mistake of embedding sql in the application then you should be including that trace in the app, if not then try the profiler and see if you can identify whether it is a database issue.That should show whether you have database queries that need to be optimised or whether the application is doing things inefficiently or whether it's another issue.I would investigate these changes first before going down the hardware route as that usually doesn't have a big or lasting impact.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-12-08 : 06:21:31
|
| The problem very likely is in SQL.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 ShawSQL Server MVP |
|
|
|
tappers
Starting Member
2 Posts |
Posted - 2010-12-08 : 09:03:32
|
| Thanks for the replies I will look into them today. Fingers crossed!Thanks again. |
|
|
|
|
|
|
SQL Server performance - PLEASE HELP