SQL Server running slow

kfinch

22y2.4k.NET

As soon as I got my .NET pages working after having a few problems I noticed that my SQL DB opened slowly and everything I do takes way too long now. I use 2000 Developers Edition on my laptop along with Visual Studio .NET, and iis running on XP Pro. Everything works, but SQL is really slow. Anybody ever seen this before? I checked the knowledge base and didn't really find anything applicable.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

kfinch22y ago
i should probably know that, but my head has been inside my own work for a while now and i'm probably missing out on a lot. i'll check it out.
0
S_Kiryazov22y ago
Yukon is the next version of MS SQL Server - 2005. It is designed to cooperate with the .net framework
0
kfinch22y ago
Exactly the same problem I'm having here. Enterprise manager used to open as fast as I could click the tabs, now it literally takes me 6-7 minutes to get a table opened. Yukon?
0
S_Kiryazov22y ago
I see. I've been using the .net framework for almost as long as MS SQL Server so I can't tell difference. But it's really taking ages to browse a database with Enterprise Manager, then another several ages while I browse the tables. Once browsed the tables open quick. If there is such problem I hope they've got it fixed in yukon.
0
kfinch22y ago
Yes, but I'm actually opening SQL through the Enterprise Manager, and it's taking forever all the sudden to get to a table. If I do some query from a page it works fine. I'm wondering if during the whole .NET Framework setup if something can get dorked up in SQL Server.
0
S_Kiryazov22y ago
Do you use user controls? I managed to achieve a serious performance drawback using user controls. I had whole site that consisted only of one aspx page with plenty of user controls being shown and hidden depending on some conditions. But even if user controls were not displayed their Page_Load events fired and also the DB queries contained in them. Maybe that's it.
0