SQL Server running slow

Question

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.

kfinch · Answer

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.

S_Kiryazov · Answer

Yukon is the next version of MS SQL Server - 2005. It is designed to cooperate with the .net framework

kfinch · Answer

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?

S_Kiryazov · Answer

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.

kfinch · Answer

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.

S_Kiryazov · Answer

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.