Hi

I found a possible solution:

ADO SQL is providing two relevant properties for defining a Time-Out in Visual Basic:

#1 CommandTimeOut

#2 ConnectionTimeOut

The last property indicates how long to wait while establishing a...

Yes, the SQL Browser is running:

2015-09-08 10:48:26.02 Server Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)

Jun 28 2012 08:36:30

Copyright (c) Microsoft Corporation

Standard...

Dear Augusto,

once again, the reason for the database being that slow is caused by a wrong Hyper-V configuration.

We do not use VMWare, but Hyper V.

Here some data of our vm:

NUMBER OF VM: 1

RAM: 16 GB (static)

CORES: 4

HD: IDE, 150 GB.

Filesize (mdf): 5.92 GB

Filesize (log): 3.93 GB

The capacity of the cpu (VM) during the query...

Yes, I think so, too...

I guess, this is another topic, isn't it.

Hello,

I made some test series with the combination of the db showing apparently slow query execution times, sql server 2008 r2, windows server 2008 r2 running a vm under hyper...

:(Sorry, again... I have been looking forward too early. I am now up to a certain point...

Did the following:

Copying the original database for test purposes, upgraded it to 90% comp....

Basically...

@Lynn Yes 🙂

Basically, updating the statistics was a pretty good idea.

The execution time of a certain query could be reduced from more than 10 mins down to 1 minute.

For some reason, I...

:hehe::w00t::-P:-D

No words. 😉

Before your optimization (updating statistics): Query Execution Time: >>600 s

After updating statistics: Query Execution Time approx. 65 s

I am thinking about updating statistics regularly now.

What would you recommend...

Here some screenshots...

thank you....

So, better change recovery model of database to complete ?

Yes, exactly.

In the picture above, I choose transaction log (Transaktionsprotoll in German) and select the database.

But I guess, with simple recovery no log file is needed.