Re: Performance really poor if calling data from sql clients

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: Need Feedback : problem since applying SP2
    ... aspnet_wp.exe recycles itself if there is a lock or memory leak ... > database access after applying .net framework SP2. ... > The error message indicates a security problem for the web ... > server to connect to the SQL server (it says Sql server is ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Need Feedback : problem since applying SP2
    ... database access after applying .net framework SP2. ... I had a couple of web services which exposed SQL server ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Import data from multiple acces db
    ... How can I change the filename for an Access Connection? ... The really problem is that the database access is ... > My idea is to insert database location on an sql server table and use this ... > I try to made a dts but i cannot succeed in. ...
    (microsoft.public.sqlserver.dts)
  • Re: Sql Server doesnot exist or access denied
    ... // ...do your database access here ... Gomathi wrote: ... My connection string is fine and I am able to log into SQL Server via Enterprise manager ok. ... I have just re-installed .net 1.1 and installed IIS on my local machine. ...
    (microsoft.public.dotnet.framework.adonet)
  • Import data from multiple acces db
    ... I need to import data from database access to sql server database, ... I try to made a dts but i cannot succeed in. ... I have an sql server 2000 sp3a ...
    (microsoft.public.sqlserver.dts)
Loading