Is there any other way to find what causing the tempdb log growth other than running a server side trace?

Now, for a simple answer without running any queries: Both applications are using tempdb and contributing to its growth.

You need to monitor the size of the tempdb, both mdf and...

Paul,

Is Microsoft mentioned about this blocking when large reports runs?

For us blocking occurring even when one user is running a larger report & the report is timing out from...

I did come across the same issue but I did not find the cause for restore failure. I appreciate if you could you provide more details, if you find the...

On my server, SSL certificate is already there. So where can...

Perfmon has no idea, the OS simply see's each disk as an individual volume, it does not know what that volume consists of. Each disk is simply a disk to...

Thank you mangeshd,

Each disk has 150 spindles in it. So what ever the value I gathered from Perfmon for Avg Disk Queue length should be divided by 150 right?

and is...

On a san, assuming it's properly configured, what you're seeing as "disks" in your OS and SQL Server should be, not a single monolithic disk, but a whole bunch of...

System: Processor Queue Length: (N/A) This counter shows the number of threads in the processor...

It might be due to low memory while running DBCC CHECKDB. There is a chance that the sql server stop responding because of low memory & cause the log shipping...

We a dedicated SQL server 2005 EE x64 with SP3.

RAM: 16 GB

Max memory: 12 GB

Min memory: default i.e 0

Lock pages in memory...

System: Processor Queue Length: (N/A) This counter shows the number of threads in the processor queue. Monitor this counter to ensure that it remains less than two times the number...

I'm using the stored procedure dtasp_RebuildIndexes provided by BizTalk and it's only rebuilds indexes for 10 tables inside the database BizTalkDTA.

The database size is 7 GB

We have 16 GB RAM (But We have 3...

any more thoughts to implement this?