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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-07-17 : 00:58:00
|
| Dear All,our application is connected to a database namely 'appsdblive' previously it is very fast, but now it became very slow. it is taking 8 sec to open a popup. previously it takes 1 sec. please suggest me waht are the first steps to tune the database.the environment is sql server 2000 stnd edition on windows 2003 server.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-07-17 : 01:31:34
|
| Really Great post Tara....thank you very much.backingup databases on daily will give good performance?ArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-17 : 01:35:30
|
"backingup databases on daily will give good performance?"Of-couse not. It ensure that you have a backup copy in case anything went wrong. Your thread's title is "database maintenance", and Tara is addressing that point.For tuning. . . quote:
To figure out what is going on, you need to run SQL Profiler and Performance Monitor.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-07-17 : 01:54:45
|
| Some of the jobs Tara has outlined such as defrag and update statistics will greatly assist in maintaining good performanceJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-07-17 : 06:45:55
|
| I'm a Big FAN of TARAArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
|
|
database maintenance