http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

As for how you identify corruption, I answered that in the thread you started on tuning TempDB.

p.s. Please in future don't start multiple threads for the same problem, you just...

As per Books Online:

For per-second counters, this value is cumulative. The rate value must be calculated by sampling the value at discrete time intervals. The difference between any two successive...

Use the link given above, specifically the page titled "Identifying Contention on Allocation Structures Using Wait States". As stated in the other thread, allocation contention is the main reason to...

Monitor for allocation contention. That's all that multiple files and traceflag 1118 are for, if you don't have allocation contention then there's no point in adding the traceflag.

Ed's right, with...

mqbk (4/5/2013)

---

GilaMonster (4/5/2013)

---

Check the SQL error log. Are you seeing recovery model changes? Do you have any other scheduled jobs that do anything to the log (including truncate it)? Do...

Check the SQL error log. Are you seeing recovery model changes? Do you have any other scheduled jobs that do anything to the log (including truncate it)? Do you have...

Am I the only person who gets 'I don't think that's true' replies to their posts from a certain person and am I the only one annoyed by it?

I can...

ScottPletcher (4/5/2013)

---

I don't think that's true. If it is, it...

They can be radically different.

For example, I worked with a card processing company a few years back, their RTO was minutes. Literally, every minute they were down they were...

System tables in the master database, but no, I was not suggesting DML triggers on the system tables.

DDL triggers

http://msdn.microsoft.com/en-us/library/ms190989%28v=sql.105%29.aspx

You've seen the stairway article series on that...

The number of log files is irrelevant.

What, exactly, does the log backup job do? Post the sql script from it if you can.

There are two common causes of this error:...

Have you considered DDL triggers?

If you're doing a presentation on bulk-logged, maybe there's something in here for you?

http://www.sqlservercentral.com/articles/Recovery+Model/89664/

If you want to log a case with product support,...