this is a common thing because those jobs that generate a lot of transaction log records create a big contention for replication stored procedures. You could stop the Log reader...

Why are you saying that it won't parse ? Is this happening when...

good luck,

Let us know how it went 😉

hawg (10/1/2007)

---

We have a development server where I was trying to setup a Linked Server. When I tried to set it up I was told that I couldn't do...

A very important part of monitoring is to setup a BASELINE so that you "know" your system workload effects under "normal" conditions.

mjschwenger (9/30/2007)

---

I do not believe that this is an issue of using bind variables or literals.

Please, note that the slow statement is the one that uses bind parameters, not literals....

that is definitely a client-side issue.

select * from sys.dm_exec_sessions -- 2005 style 😉

May I suggest you NEVER, EVER use EM nor SSMS for DDL ? You want to be in control of what is actually going to happen. It does not take...

When you add a new column it does takes time to go through the pages locking people (connections) out allocating / splitting pages for the column space and updating all...

Great, thanks for the feedback!

you run Profiler traces on an SQL Server 2005 with 2005 profiler client tool. By default it reads in microseconds and displays in milliseconds. You can change the display to...

Actually microsecond tunning is the as millisecond tunning the actual thing is that previously a very large amount of very low duration queries would escape under the radar and now...

glad to help

http://support.microsoft.com/kb/916706/en-us