Are you getting the same for all databases or just a single one.

Can you try firing sp_helpdb and check whether something is unusual for this database?

my mistake. Thanks for correcting

Please check the default trace file stored in errorlog folder.

To find your default trace

SELECT *

FROM fn_trace_getinfo(default);

GO

USe the following function to dump the trace details into a table

SELECT * FROM...

Removing unwanted objects is a good thing, but thats less likely to be the reason for your problem. Do a thorough analysis of the problem.

Start checking from Task manager...

If interested please read http://strictlysql.blogspot.com/2010/02/database-server-is-slow-can-you-please.html%5B/url%5D

@Gail,

To quote books online

When EMERGENCY is specified, database is...

@ritesh-2,

Welcome 🙂

@ritesh-2,

CPU used by SQL Server can be found from sys.dm_os_ring_buffers.

Refer http://strictlysql.blogspot.com/2010/06/finding-cpu-utilization-in-sql-server.html%5B/url%5D

@andriod,

Try "sqlcmd -L" on the command prompt and check whether it helps you.

Hi Stanley,

Good and informative article. Does it require any ports to be opened?

@kevin77:

it seems to me that the database should be smart enough to analyze the SELECT query and recognize that it cannot acquire all the necessary data using...

@tosscrosby,@Bhuvanesh,

Yes true that girls/ladies are lesser represented. But right now SQL communities' top contributers are women.

Gail Shaw

Kalen Deanley

Kimberly tripp

Michelle ullford (sqlfool)

Lyn shea

Personally, I am huge huge huge...

Even I work for Govt firm of sorts and its same here as well..

SA's handle stuff like windows patching..DBAs do the DB patches,hotfix..

DBAs do have windows logins to server with...

@maxibeck,

check the attachements given at the end of the article.

Refer to the article belowto narrow down on the queries that are casuing the tempdb to grow.

http://strictlysql.blogspot.com/2010/03/whats-causing-my-tempdb-to-grow-sql_17.html