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

Re: tempdb is huge

From	tbone <tony.despain@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: tempdb is huge
Date	2012-06-07 13:06 -0700
Organization	http://groups.google.com
Message-ID	<616dbdd9-a621-44c9-8c31-34ca014b4b7c@googlegroups.com> (permalink)
References	<09bfa005-8f20-4bd6-808a-4e8c609f2b49@googlegroups.com> <35cb27a7-4f30-4093-9b97-9b25ecedf98e@googlegroups.com> <XnsA06BDB8DEA7F8Yazorman@127.0.0.1>

Show all headers | View raw

I went into enterprise manager and used the gui, I unchecked the auto grow and specified the size that was in the box already.  It was about 200 GB.  I am looking at I/O and nothing is writing to the tempdb file that I can see...

I have tried starting it in single user mode but I can't connect (i get an hourglass) and this is the output of the startup:

C:\Program Files\Microsoft SQL Server\MSSQL\Binn>sqlservr -m
2012-06-07 14:02:52.59 server    Microsoft SQL Server  2000 - 8.00.2050 (Intel X
86)
        Mar  7 2008 21:29:56
        Copyright (c) 1988-2003 Microsoft Corporation
        Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2012-06-07 14:02:52.60 server    Copyright (C) 1988-2002 Microsoft Corporation.

2012-06-07 14:02:52.60 server    All rights reserved.
2012-06-07 14:02:52.62 server    Server Process ID is 1348.
2012-06-07 14:02:52.62 server    Logging SQL Server messages in file 'C:\Program
 Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2012-06-07 14:02:52.64 server    SQL Server is starting at priority class 'norma
l'(4 CPUs detected).
2012-06-07 14:02:52.65 server    Performance monitor shared memory setup failed:
 -1
2012-06-07 14:02:52.76 server    SQL Server configured for thread mode processin
g.
2012-06-07 14:02:52.78 server    Using dynamic lock allocation. [2500] Lock Bloc
ks, [5000] Lock Owner Blocks.
2012-06-07 14:02:52.90 server    Attempting to initialize Distributed Transactio
n Coordinator.
2012-06-07 14:02:54.01 spid3     Warning ******************
2012-06-07 14:02:54.01 spid3     SQL Server started in single user mode. Updates
 allowed to system catalogs.
2012-06-07 14:02:54.03 spid3     Starting up database 'master'.
2012-06-07 14:02:54.18 server    Using 'SSNETLIB.DLL' version '8.0.2039'.
2012-06-07 14:02:54.18 spid5     Starting up database 'model'.
2012-06-07 14:02:54.21 spid3     Server name is 'UT2KIV05'.
2012-06-07 14:02:54.21 spid7     Starting up database 'msdb'.
2012-06-07 14:02:54.21 spid10    Starting up database 'FDM_Data'.
2012-06-07 14:02:54.21 spid8     Starting up database 'alm_rpts'.
2012-06-07 14:02:54.21 spid9     Starting up database 'QRM_HenryDB'.
2012-06-07 14:02:54.28 server    SQL server listening on 10.232.225.235: 1433.
2012-06-07 14:02:54.28 server    SQL server listening on 127.0.0.1: 1433.
2012-06-07 14:02:54.34 spid5     Clearing tempdb database.
2012-06-07 14:02:54.35 server    SQL server listening on TCP, Shared Memory, Nam
ed Pipes.
2012-06-07 14:02:54.35 server    SQL Server is ready for client connections

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | 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