There is no way to tell where the trace was initiated from. You can just get the info you see there and the event and column info from fn_geteventinfo

Whether or not data stays in memory is largely a function of the size of your memory and how volatile your cache is. Tables won't stay in memory unless they're...

Brandie Tarvin (2/16/2011)

---

Not to take away from Grant's book, but if you need information fast, Google "SQL Server Performance Tuning." There are literally hundreds of articles out there. Or search...

Brandie Tarvin (2/16/2011)

---

SQL is assuming the _1 is forcing a trace number. Remove it.

exec @rc = sp_trace_create @TraceID output, 0, N'\\servername\D$\Folder\Trace_1', @maxfilesize, NULL, @filecount

Should be

exec @rc = sp_trace_create @TraceID output,...

Anna_SQL (2/16/2011)

---

Thank you, when you say run a server trace, is that using SQL profiler?

One time when one of our servers got a hang or ran very slow, I tried...

Your second parameter, which is 0, should be set to 2, which enables rollover.

Sounds like you have both problems. I'd attack each one, but try to do it individually so that you can determine if adding memory helps or if getting better, more,...

Just because it's faster to save unstructured data in a striaght write to disk than it is to a database. You're dealing with all the overhead of SQL Server when...

Performance monitor is absolutely one of the tools you want to know how to operate to understand what's happening on the server, but if you're trying to determine why a...

It's written for 2005, but it's largely applicable...

Pouliot Philippe (2/16/2011)

---

Grant Fritchey (2/16/2011)

---

That is a GIANT topic. You really need to develop your own story. If you don't have the knowledge yet to be able to walk someone...

Well, no, not really. You're saying that the other tables have no type of relationship to the other data at all, but, you want to somehow put it all together.......

Please read the article I posted. That's how you do a trace.

I ran a series of tests, years ago, where I opened multiple default traces on SQL Server. I had 20 running at the same time and i didn't change performance...

That is a GIANT topic. You really need to develop your own story. If you don't have the knowledge yet to be able to walk someone through what you would...