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 |
|
srivatsahg
Yak Posting Veteran
71 Posts |
 Posted - 2009-07-02 : 08:19:25
|
| Hello Our application database has been growing exponentially over the last two months.Because of this we are having side effects of decrease in the performance of the database as a whole.Any suggestions/advices in this direction(precautionary steps/tips and tricks) deeply appreciated.RegardsSrivatsa |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-07-02 : 08:44:01
|
| Replication is best...Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceled |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-07-02 : 10:20:00
|
quote:
Originally posted by senthil_nagore
Replication is best...
For what?--Gail ShawSQL Server MVP |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-07-02 : 10:22:39
|
quote:
Originally posted by srivatsahg
Any suggestions/advices in this direction(precautionary steps/tips and tricks) deeply appreciated.
I'm guessing that little has been done to tune code and indexes. Take a look at these articles, they go over a way to find the worst performing queries. Once you've found the biggest problems you need to see about optimising. That may be fixing the code, it may be tuning the indexee, it's usually both. If you get into problems with the tuning of queries, post here, there are people here who are very experienced at performance tuning.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 |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-07-02 : 18:24:56
|
quote:
Originally posted by senthil_nagore
Replication is best...Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceled
Donot just blindly answer. |
|
|
|
|
|
|
Application Database growing ..Worries increasing