Re: Performance really poor if calling data from sql clients

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: can not stop and restart SQL server 2005
    ... I think the problem has to do with the machine rights, not SQL server. ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: Alternative to profiler
    ... Do you have sa rights on the SQL Server? ... Trace instead of profiler. ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Slow during Inserts
    ... http://www.support.microsoft.com/?id=q224587 Troubleshooting App ... Disk Monitoring ... Andrew J. Kelly SQL MVP "James Juno" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: Log file wont Shrink in Simple Recovery Mode
    ... What does DBCC OPENTRAN() say? ... > Andrew J. Kelly SQL MVP ... As I stated the recovery model is set to simple so it ...
    (microsoft.public.sqlserver.server)
  • Re: Table size and sp_spaceused
    ... It's just that reindexing does nothing for blobs in 2000 but I am pretty ... Andrew J. Kelly SQL MVP ... "John McLusky" wrote in message ...
    (microsoft.public.sqlserver.server)