Re: Why the performace differs?

Yes, SQL Server is having the highest piority and consumes about 800MB
from the memory (I made this by configure the SQL Server from the
Enterprise Manager)

but still very slow.


*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: memory leak when quering from SQL server
    ... > I have a query that gets binary info from the SQL Server. ... > Actually it consumes the amount of memory as defined in the SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: More than 2G of Ram
    ... The wierd thing is that enterprise manager says it can go up ... to 2G since that is all standard edition can support. ... Sql Server could not spawn process_loginread thread ... > allow sql to use memory above 2G? ...
    (microsoft.public.sqlserver.server)
  • Re: Pressuring GC to give up clean up memory.
    ... Basically, the powers that be, decided that the app is going to be on the same box as the SqlServer2k5 64-bit, which consumes ungodly amounts of memory. ... If SQL Server is configured to consume exactly what it needs, and there is enough memory left to let your application run without the risk of excessive paging you are set, else you are in a world of pain, playing ticks with the GC won't help. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Maximum practical number of databases per SQL Server 2000 Inst
    ... The error I was getting was something like "Out of Memory". ... I enabled the "AutoClose" property my small DBs, ... in my test environment without any problems or SQL Server process to increase ... > Enterprise Manager took 32 seconds to render the screen. ...
    (microsoft.public.sqlserver.server)
  • Re: Why the performace differs?
    ... SQL Server is having the highest piority and consumes about 800MB ... > from the memory (I made this by configure the SQL Server from the ...
    (comp.databases.ms-sqlserver)