Re: Performance really poor if calling data from sql clients

This does not sound like a SQL Server issue but something to do with how the
client is connecting. Any chance the laptop is set to save power and the
disk is powering down after a few minutes?

--
Andrew J. Kelly SQL MVP


"Stephan (Germany)" <StephanGermany@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:A2D0B087-2F60-4D6B-9064-53ED8F1134AD@xxxxxxxxxxxxxxxx
Maybe this can help you:
the most time consuming period (waiting time) will arise if I connect the
server. If I pause a while and send another SQL command, the
reestablishing
of the connection (same connecting string) needs again a while and then I
can
fire different sql commands which will be executed in an acceptable speed.


Yours
Stephan

"Andrew J. Kelly" wrote:

What is the compatibility level of the db? If it was a db that was
upgraded
it may be in 80 compatibility mode.

--
Andrew J. Kelly SQL MVP


"Stephan (Germany)" <StephanGermany@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:19B125B0-21FA-45E4-AD16-E464D6FFC3E6@xxxxxxxxxxxxxxxx
Running of sp_updatestats fails. Error: stats_ver_current is not a
built-in
function.

"Andrew J. Kelly" wrote:

I can't vouch for any of the VS components when it comes to
performance
since I don't use them for database access. But you should be able to
use
profiler to see what is happening on the sql server end. Also what
does
the
query plan look like? Is it optimal? Did you run sp_updatestats?

--
Andrew J. Kelly SQL MVP


"Stephan (Germany)" <StephanGermany@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
in
message news:FB05EA03-F277-4FBE-B1AB-A7C8C767B41D@xxxxxxxxxxxxxxxx
Hello,

I have installed SQL2005 developer edition on a laptop (2 GB RAM),
VS2005
on
another computer. The database is quite small (nearly no data or
some
test
data). The performance is still really bad:
xxx each time you open the server explorer in VS2005 and you use
"show
table
data" (takes at least 20 sec., sometimes time out).

xxx each time I read from tables within my application (I'm not
reading
the
full table, I'm selecting the data, number of records < 5)

What can be done in order to determine the performance consuming
element/object? The network the computer are attached consists of
less
than 5
users (1 GBit backbone).

Are there any configuration aspects which can help to improove the
performance?
Network pack size = 4096
Max. number of concurrent connections = 0
Boost SQL server priority is not checked
Max. server memory = 2 GB

Thanks,
Stephan








.

Relevant Pages

  • Re: Cannot connect a remote sql server
    ... Try disabling the firewall on the client. ... I would also make sure the SQL Browser service is running and that the login credentials you're using have rights to the default database. ... I've also written a long chapter on connecting that has helped a lot of people establish and maintain connections. ... I don't know if this matter but the server I'm trying to connect to is SQL Server 2000. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Website Administration has errors
    ... The application is configured to use SQL Server ... permission issue when the webadmin site page try connecting to the target ... since the web admin site will use the ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • SQL Express Remote Connections
    ... TCP/IP is enabled (because i can get there from the local subnet) and if i go to the properties of the connection and go to IP Addresses they are all active but only the primary host ip is enabled. ... When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.sqlserver.setup)
  • Re: problem to connect sql server 2005 from localhost (W2k3)
    ... Andrew J. Kelly SQL MVP ... "Andrew J. Kelly" schrieb im Newsbeitrag ... Are you sure the account that you log onto the local server has permissions to properly access SQL Server? ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)