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 |
|
paul.rowling
Yak Posting Veteran
81 Posts |
 Posted - 2003-05-08 : 07:43:16
|
| Hi,This morning I imported some data from an interbase .gdb file using an ODBC driver. Since then, Enterprise Manager is running really slowly, it takes an age to open tables, switch between databases etc. When I use query analyzer it takes a while to connect to the database server and then it can take over 10 minutes to parse a simple select query. The database runs locally and is accessed locally at the same machine.What could be causing this slow performance??CheersPaulP.S I'm relatively new to sql server!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-08 : 12:30:54
|
| Have you run Performance Monitor to see what the problem is? How about SQL Profiler? Since Query Analyzer is also causing problems (Enterprise Manager uses a lot of client resources so it should be used minimally), you should start with the monitoring tools to identify if the problem is hardware or software.Tara |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-08 : 13:31:54
|
| Just shut it down and restart EM and QA...I've seen it get funky sometimes, if you have to reboot the client...Tara could be (and often is) right, but I get huch it's just O/S or the apps....Brett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-08 : 13:36:47
|
quote:
Just shut it down and restart EM and QA...I've seen it get funky sometimes, if you have to reboot the client...Tara could be (and often is) right, but I get huch it's just O/S or the apps....Brett8-)
Yeah I guess I assumed that he had already tried that since that would be the first thing to do when troubleshooting a problem.Tara |
|
|
|
paul.rowling
Yak Posting Veteran
81 Posts |
Posted - 2003-05-08 : 14:09:43
|
| Hi,I had already tried stopping ans restarting EM, and I also rebooted PC but the problem remained. I will try Tara's suggestion though.CheersPaul |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-08 : 16:24:49
|
| Any Luck?Did you bounce the box?Brett8-) |
|
|
|
|
|
|
Enterprise Manager So Slow