Groups > comp.databases.ms-sqlserver > #1106

tempdb is huge

Path	csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
From	tbone <tony.despain@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	tempdb is huge
Date	Thu, 7 Jun 2012 10:46:57 -0700 (PDT)
Organization	http://groups.google.com
Lines	5
Message-ID	<09bfa005-8f20-4bd6-808a-4e8c609f2b49@googlegroups.com> (permalink)
NNTP-Posting-Host	209.20.103.246
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
X-Trace	posting.google.com 1339091303 3029 127.0.0.1 (7 Jun 2012 17:48:23 GMT)
X-Complaints-To	groups-abuse@google.com
NNTP-Posting-Date	Thu, 7 Jun 2012 17:48:23 +0000 (UTC)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=209.20.103.246; posting-account=m5z2xQoAAACdflVHxlKtq0DEgoIcz3yL
User-Agent	G2/1.0
X-Received-Bytes	1240
Xref	csiph.com comp.databases.ms-sqlserver:1106

Show key headers only | View raw

I am running sql server 2000 and have noticed that the tempdb .mdf file is 200 GB  The largest user db .mdf file is about 130 GB.  I have restarted the server many times but it stays at 200 GB.  It is filling up the disk.  Is there any way to shrink this or is the user db causing it to grow so large?

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

tempdb is huge tbone <tony.despain@gmail.com> - 2012-06-07 10:46 -0700
  Re: tempdb is huge tbone <tony.despain@gmail.com> - 2012-06-07 11:47 -0700
    Re: tempdb is huge Erland Sommarskog <esquel@sommarskog.se> - 2012-06-07 21:34 +0200
      Re: tempdb is huge tbone <tony.despain@gmail.com> - 2012-06-07 13:06 -0700
  Re: tempdb is huge tbone <tony.despain@gmail.com> - 2012-06-07 13:54 -0700

csiph-web