sql server connect:
Hi,
I am using SQLServer on my development laptop, and it's running without
any problems since at least 6 or 7 months. Suddenly, since yesterday,
when I start the Entreprise Manager, it takes absolute AGES (minutes,
with a very intensive disk activity) until it shows the console root,
and each click on a table takes again ages until the rows are shown.
Even paging takes now 10 times longer as before. My DB is very snmall,
something like 50,000 rows in total max. A double click on the table
icon of the largest table (20,000 rows) takes 2 MINUTES to complete ! A
click on the "Run" icon in the tool bar takes more than 10 seconds to
complete, to show 40-50 rows !
What's going on ? Why suddenly, where I can't remember having done
anything special these last days. And more importantly, how do I get
back to the previous status, where everything was real quick ?
Thanks for help.
Hi, Further to my previous post, I just noticed that the memory and virtual memory used by the sqlmangr (which I suppose is the DB server) is RIDICULOUSLY small (1,16 Meg / 1,25 Meg respectively, I'm running Win XP Pro SP2). I think I remember this was at least 10 times higher before. How do I change this ? Bernard [quoted text, click to view] bthouin wrote:
> Hi,
>
> I am using SQLServer on my development laptop, and it's running without
> any problems since at least 6 or 7 months. Suddenly, since yesterday,
> when I start the Entreprise Manager, it takes absolute AGES (minutes,
> with a very intensive disk activity) until it shows the console root,
> and each click on a table takes again ages until the rows are shown.
> Even paging takes now 10 times longer as before. My DB is very snmall,
> something like 50,000 rows in total max. A double click on the table
> icon of the largest table (20,000 rows) takes 2 MINUTES to complete ! A
> click on the "Run" icon in the tool bar takes more than 10 seconds to
> complete, to show 40-50 rows !
>
> What's going on ? Why suddenly, where I can't remember having done
> anything special these last days. And more importantly, how do I get
> back to the previous status, where everything was real quick ?
>
> Thanks for help.
>
Sorry, I looked up the wrong guy: I should have looked at the sqlservr.exe process. That one uses 30,7 / 44,3 Meg of mem /virtual mem. The enterprise manager uses 23 / 19 megs, and is still dead slow, although I configured SQLServer (right-click on server, properties, memory ) to use between 50 and 300 megs of mem. Next action ?? Bernard [quoted text, click to view] bthouin wrote:
> Hi,
>
> I am using SQLServer on my development laptop, and it's running without
> any problems since at least 6 or 7 months. Suddenly, since yesterday,
> when I start the Entreprise Manager, it takes absolute AGES (minutes,
> with a very intensive disk activity) until it shows the console root,
> and each click on a table takes again ages until the rows are shown.
> Even paging takes now 10 times longer as before. My DB is very snmall,
> something like 50,000 rows in total max. A double click on the table
> icon of the largest table (20,000 rows) takes 2 MINUTES to complete ! A
> click on the "Run" icon in the tool bar takes more than 10 seconds to
> complete, to show 40-50 rows !
>
> What's going on ? Why suddenly, where I can't remember having done
> anything special these last days. And more importantly, how do I get
> back to the previous status, where everything was real quick ?
>
> Thanks for help.
>
Make sure you don't have ODBC tracing turned on. Also make sure you have the latest service pack applied. Having auto close turned on for a database can make Enterprise Manager slower as well but usually just with expanding the database node. -Sue On Thu, 28 Jul 2005 13:13:01 +0200, bthouin [quoted text, click to view] <bernard_thouin@bluewin.com> wrote:
>Sorry, I looked up the wrong guy: I should have looked at the
>sqlservr.exe process. That one uses 30,7 / 44,3 Meg of mem /virtual mem.
>The enterprise manager uses 23 / 19 megs, and is still dead slow,
>although I configured SQLServer (right-click on server, properties,
>memory ) to use between 50 and 300 megs of mem.
>
>Next action ??
>
>Bernard
>
>bthouin wrote:
>> Hi,
>>
>> I am using SQLServer on my development laptop, and it's running without
>> any problems since at least 6 or 7 months. Suddenly, since yesterday,
>> when I start the Entreprise Manager, it takes absolute AGES (minutes,
>> with a very intensive disk activity) until it shows the console root,
>> and each click on a table takes again ages until the rows are shown.
>> Even paging takes now 10 times longer as before. My DB is very snmall,
>> something like 50,000 rows in total max. A double click on the table
>> icon of the largest table (20,000 rows) takes 2 MINUTES to complete ! A
>> click on the "Run" icon in the tool bar takes more than 10 seconds to
>> complete, to show 40-50 rows !
>>
>> What's going on ? Why suddenly, where I can't remember having done
>> anything special these last days. And more importantly, how do I get
>> back to the previous status, where everything was real quick ?
>>
>> Thanks for help.
>>
>> Bernard
Don't see what you're looking for? Try a search.
|
