Unanswered: slow LOCAL access with EM on MSSQL 2000 - extensive disk usage...
I have strange problem - since some date I have a very very slow response from my LOCAL MSSQL when using Enterprise Manager or for example Query Analyzer. In fact it seems to me all locally used tools would do the same. The slow response means that I am waiting for any action about 1-5 minutes with very extensive disk usage and nearly none CPU usage. Any local aplication I am developing have no problem - its queries are fast enough like before. The strangest thing is that when I am using Enterprise Manager from another client to connect and manage my LOCAL MSSQL, i have no such a problem, everything goes smoothly like it should. I have set-uped that only TCP-IP connection are allowed to connect my MSSQL.
It seems to me it might be some problem with Authentification?? (mixed authentification is allowed on my MSSQL. But why it is normally fast when connecting from another computer and why so slow when using LOCAL computer??
SP3 ? I didnt find it. Have SP2, on microsoft's www there only sp2. And how to check which protocol is EM using through Processes? Sorry, i am little bit confused. In fact, I enabled only TCP/IP protocol on my server. I tryed to add alias to client network utility of type TCPIP and connect to my local mssql through it, but no improvement on my problem...
In fact I have disabled using of any other protocol then TCP-IP. I need it because my server. But it worked normally, so I sont think thats reason of my problem.
I am running MSSQL2000 developer version on MS XP proffesional, so MDAD SP3 cannot be installed here.
Nothing helped me till now, really dont know what to do. In fact, I am rather connecting to my mssql server from another computer, because it works perfectly. But its a little bit hard work. I am also using VMWARE using W98 and enterprise manager on the local computer, and it also work perfectly. So I am nearly close to say something is wrong when connection to mssql or what....
Re: Solving why mssql server is runing so slowling while extenisive disk usage
yes it helped. I have found it few month ago, sorry that I did not reply to this board sooner... but thanks anyway, somebody with similar problem will be glad for you answer, me aswell, because i am sure next time it will happens to me, i wont be remember what to do