Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sbt1
Yak Posting Veteran
89 Posts |
 Posted - 2003-07-25 : 14:20:02
|
| Obviously MSDE doesn't have SQL Server's nice trace utility.But is there any way to trace the workload on an MSDE database? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-07-25 : 18:58:07
|
| Actually, there are ways to create traces and run them using extended stored procedures. Take a look in Books Online under "xp_trace" and also possibly "sp_trace". There are details in how to use them, and they should work in MSDE.I believe you can also download the evaluation version of SQL Server and install the tools, Profiler is among them, and it should work even after the evaluation period expires. |
 |
|
|
|
|
|
Any way to do a trace?