TheSQLGuru (8/5/2011)

---

It seems that based on your comments you really aren't interested in free help from an online forum. So I will offer my considerable performance tuning talents to...

Sean Lange (8/5/2011)

---

Or add a lot of auditing lines. Depending on the complexity of the parameters you can convert the logic to just t-sql block fairly easily. This lets you...

Much more advanced but usefull reading. Reffer to all releated links in the article..

http://sqlskills.com/BLOGS/PAUL/post/Survey-how-much-server-memory-is-being-wasted-(code-to-run).aspx

It's not NOW 2 against 1 for Jeff. :w00t:

These will help you debug this.

When will my backup finish?

SELECT r.[session_id]

, c.[client_net_address]

, s.[host_name]

, c.[connect_time]

, [request_start_time] = s.[last_request_start_time]

, ...

Short answer. Take tlog backups every x minutes.

I would personally shrinkg it ONCE to 2-3 GBs and then leave it alone.

All the details here :

http://www.sqlservercentral.com/articles/64582/

http://www.sqlservercentral.com/articles/Transaction+Log/72488/

the good old #1 fix for M$ :-D.

Thanks for the feedback. It'll surely help someone else later.

L8rs.

Hey Rhox I'd love to do a few tests with your particular case. Can you send me the table's definition (ddl to recreate it) along with the indexes so...

There's a message like that right after a restart (which is a not a real checkdb()). In my server it's like this :

Date7/13/2011 2:13:45 PM

JournalSQL Server (Archive n°1...

Easiest thread ever. All poster should be like that :-D.

Rhox (8/5/2011)

---

GilaMonster (8/5/2011)

---

No. Don't switch to simple. It gives...

GilaMonster (8/5/2011)

---

Ninja's_RGR'us (8/5/2011)

---

Here I do tlog backups every 15 minutes and the reindex job used to run well over that untill I updated it. I checked the log history...

Rhox (8/5/2011)

---

crashdan (8/5/2011)

---

You are up against a wall on this. You will need more storage to accomplish the task. Which will require an outage to move the log to.

also: No...

I'm not too sure what to tell you about this, but this might help.

Here I do tlog backups every 15 minutes and the reindex job used to run well over...

Ola Hallengren (8/5/2011)

---

>As for "His maint is also set up to do checkdb against the entire db or just the pieces that have changed."

The integrity check stored procedure does not...