Hey Roy,

You can put me down for virtual presentations, absolutely. Travel is something I can do, but it's very limited, so...

I need tons more information to even attempt to give you answer. A few places you should look, what process are you using to load? Is it a batch oriented...

Are you shrinking the tempdb over & over? Please don't do that. It hurts the system in lots of ways.

If whatever you're processing needs to to use that much tempdb,...

It may be an issue, and it may not. Any time someone puts forward numbers like that, you have to assume they're a guideline, not an absolute.

Are you monitoring waits?...

I'm sorry I missed Friday night. I would have loved to have hung out with you guys. Jeff's fun when you get him going. SQL Saturday in Cleveland was a...

argaen21 (2/4/2011)

---

Thanks for all the replies in this thread. Steve, the OP, and I are friends in real life. I, too, am thinking about becoming a database admin, so I...

mister.magoo (2/4/2011)

---

Hi Grant,

Thanks for that comment, but the trace is actually writing to a file on a separate physical disk, the the StopPerfTrace SP reads it in using fn_trace_gettable.

I am...

For what it's worth, I came into databases from development. I got into development after film school and four years in the Navy as a nuclear power monkey mate. I...

I will also self-promote, but only after I promote a couple of others.

There are three books that I really like that deal with being a DBA, not so much SQL...

I just left a company that did a number of migrations. We had very few issues. Most of the time the problem was in code that was deprecated. Be sure...

I see the trace is outputting to a table, is that right? If so, is it a table on the system that you're doing your testing on? That could be...

Expire date doesn't determine how many days are kept. That's a marker for old style tape backup systems.

How big is this database? Keeping 90 days worth of individual backups could...

It sounds like you have the issue isolated to a particular table. What queries are running against the table. I'd focus there. Most of the time, problems exist either in...

The company I used to work for did that annually. They would only take the backup process offline on a weekend, so all the prep was done and then testing...

I wold get rid of the ROWLOCK hints. By putting the hint in place, you're forcing the optimizer to use row locks on inserts when page locks or even table...