Ok try this:

When you open SQL Server Management Studio.

It Open a Dialogbox to "connect to Server" Specify the Servername then

goto OPTIONS>> Click on Network Protocols then Select Shared Memory from...

This seems to be a system table

and leaf page corruption in a clustered index..

check out other Posts i have posted some links from PAUL RANDAL, the checkdb Guru and...

Try

sysmail_stop_sp then

sysmail_start_sp

See if this solves the issue.

Create a Script first to drop the required contraints and then

Truncate table and reapply the constraints.

OR

Script all tables using Delete, which will work even with constraints in place.

But Remember,...

Check this thread out. Maybe this will help you understand and come to conclusion about the Growth patter.

http://www.eggheadcafe.com/software/aspnet/32188763/transaction-log-hugeat.aspx

Exactly Same Problem here.. I am this query in a job, which in return send me notifications every hour or once a day.

select * from syslogins

where createdate>=getdate()-1

Or Use this for...

Use will have to use DAC to login to SQL Server instance and then try Querying the system tables and View.

specially to get a list of all system Views select...

Well we did it, We moved all of our 15 SQL Servers (450 Databases) to a consolidated Env. To IBM DataCenters with SAN(FC) and 4 itanium 8 way boxes. And...

Check out Paul Randals Excellento Work here: http://blogs.msdn.com/sqlserverstorageengine/archive/tags/DBCC+CHECKDB+Series/default.aspx

and http://www.sqlskills.com/blogs/paul/

Try Server Side trace for Capturing any specific DB Activity or Overall.

Before doing that, Check for available Space on your BOX, because these traces can get HUGE.

Now Do you...

You can run a server side trace.

Also What is the Data and Log File growths/Sizes.

Here is a rule, as your Files Grow in Size, there Growth% should be Decreased likewise....

I have tried this before and found this resolved my issues.

you can try this, but this doesnt guarantee a solution in your situation.

What are your SQL Server Service account Running...

Try to dump the trace into a SQL Table on the same server and then run queries against the SQL Table. use/wrap system functions to Query the Trace info db_name(databaseid),object_name(objectid)...

Try This:

USE MASTER

Alter database tempdb modify file (name = tempdev, filename = 'E:\NEWFOLDER\tempdb.mdf')

go

Alter database tempdb modify file (name = templog, filename = 'F:\LOGFOLDER\templog.ldf')

Well here are some of my thoughts on the issue and you might already be aware of the same....

TEMP DB is RECREATED everytime you recycle SQLServer Services or BOX.

This will...