RE: How to improve SQL Server operations
From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 12/16/04
- Next message: Kurt Schroeder: "Re: join two queries"
- Previous message: Dan Guzman: "Re: How to improve SQL Server operations"
- In reply to: Sniper: "RE: How to improve SQL Server operations"
- Next in thread: David Portas: "Re: How to improve SQL Server operations"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 16 Dec 2004 06:23:04 -0800
That's just the point. The only useful information you've given us is "slow".
There are a million possible reasons why the performance of your application
is "slow" - some of which will have nothing to do with SQL Server. You can't
expect an answer that says "try these 10 things and it will go fast".
What you need to do is pin down the component(s) or process(es) that are
causing problems. Don't make any assumptions. Take things one step at a time:
application, client hardware, network hardware, server hardware, server OS,
server applications - all these need to be taken into consideration. Also,
find out when the problem started. Has it ever worked acceptably? If so, what
changed? Maybe your business has outgrown your original configuration.
With regard to SQL specifically. SQL Profiler is one useful tool to
determine exactly what processes are bottlenecks in your system. The link
that Alejandro posted includes lots of stuff on tuning your SQL Server config
once you are armed with a bit more information about the nature of the
problem.
-- David Portas SQL Server MVP --
- Next message: Kurt Schroeder: "Re: join two queries"
- Previous message: Dan Guzman: "Re: How to improve SQL Server operations"
- In reply to: Sniper: "RE: How to improve SQL Server operations"
- Next in thread: David Portas: "Re: How to improve SQL Server operations"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
