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 |
|
SQLDiva
Starting Member
26 Posts |
 Posted - 2004-09-01 : 06:04:25
|
| I'm at my wits end. I've spent night after night trying to figure this problem out, maybe someone can give me any idea to try.We have an external program that reads from a series of tables, then rights out to a different set of tables. This has been running successfully for months. All of a sudden, on one server, the time it took increased 10 fold. Here are some steps I've taken: - ruled out network card (other databases on same server are fine) - rebooted all servers - reindexed db - ran checkdb - performed a shrink - defragmented all drivesNothing has changed as far as the database structure, indexes, etc. I'm SO frustrated, and the hardware people are pointing to the db, saying it's a db problem, but I can't find a problem anywhere. I'm exhausted and frustrated and would take ANY suggestions at all.Thanks, Ann |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2004-09-01 : 06:38:01
|
| Couple of thoughts...First, has the external program changed in anyway ?Next, try UPDATE STATISTICS with FULLSCANAnd... are there any TRIGGERS added on the tables that are being updated. This is cause a performance issue.(If you have had a previous benchmark results of performance on this server, that would greatly help)Even if not, run a profiler trace on the server and review it for the SQLs fired by the external program that are taking longer times or high "reads". Analyse these SQLs and see if any indexes are required.Hemanth GorijalaBI Architect / DBA |
 |
|
|
SQLDiva
Starting Member
26 Posts |
Posted - 2004-09-01 : 08:30:48
|
| External program hasn't changed. NO Triggers, but I will trip the update statistics with fullscan.I'm working on analyzing the profile trace now, but not having any luck finding anything that's not exactly what it should be.Thanks,Ann |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-01 : 12:52:45
|
| Have you run Performance Monitor to determine if you now have a hardware bottleneck? Has the amount of data increased?Tara |
|
|
|
|
|
|
|
|
Urgent performance problems