Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #140
| Path | csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| From | Erland Sommarskog <esquel@sommarskog.se> |
| Newsgroups | comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming |
| Subject | Re: SQL Server 2008 Express: Odd Memory and Disk Behaviour |
| Followup-To | comp.databases.ms-sqlserver |
| Date | Thu, 7 Apr 2011 08:21:33 +0000 (UTC) |
| Organization | Erland Sommarskog |
| Lines | 32 |
| Message-ID | <Xns9EC069614566Yazorman@127.0.0.1> (permalink) |
| References | <4mvpp658pb4p4o1c53k271n6inccrqbmte@4ax.com> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=us-ascii |
| Content-Transfer-Encoding | 7bit |
| Injection-Date | Thu, 7 Apr 2011 08:21:33 +0000 (UTC) |
| Injection-Info | mx03.eternal-september.org; posting-host="G7+Jz22XqYCG8C6rb1H3YA"; logging-data="21153"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18gVvcjz52VgDG/bsG6u8th" |
| User-Agent | Xnews/2005.10.03 Mime-proxy/1.4.c.4 (Win32) |
| Cancel-Lock | sha1:+GQ18WyBM3whTVcH6ZkjNFa/16g= |
| Xref | x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:140 |
Cross-posted to 2 groups.
Followups directed to: comp.databases.ms-sqlserver
Show key headers only | View raw
Gene Wirchenko (genew@ocis.net) writes: > 1) The odd memory behavour is that SQLSERVR.EXE is taking about > 600MB doing nothing! Does it ever release memory? Sure, I was doing > something yesterday. Yes, if someone else needs it. But SQL Server is designed to grab as much memory as it can. Reading data from the cache is so much faster than reading from disk. You can use sp_configure set to the max amount of memory for the buffer pool. On a developer machine, this can be a good idea to avoid that SQL Server inflates too much so that other things you are not using for the moment are swapped out. > 2) There are a lot of 368 byte files in C:\Documents and > Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19. By > a lot, I mean millions. By "millions", I mean exactly that. This is > no exaggeration. Defrag reports about 5.5M files on my system. I > can not run chkdsk /f on my C: drive at boot and have it take less > than hours to run. Any particular reason you suspect SQL Server? Have you looked inside of these files? -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
SQL Server 2008 Express: Odd Memory and Disk Behaviour Gene Wirchenko <genew@ocis.net> - 2011-04-06 17:06 -0700
Re: SQL Server 2008 Express: Odd Memory and Disk Behaviour Erland Sommarskog <esquel@sommarskog.se> - 2011-04-07 08:21 +0000
Re: SQL Server 2008 Express: Odd Memory and Disk Behaviour Gene Wirchenko <genew@ocis.net> - 2011-04-07 13:08 -0700
Re: SQL Server 2008 Express: Odd Memory and Disk Behaviour Erland Sommarskog <esquel@sommarskog.se> - 2011-04-07 23:28 +0200
Re: SQL Server 2008 Express: Odd Memory and Disk Behaviour Gene Wirchenko <genew@ocis.net> - 2011-04-07 18:15 -0700
csiph-web