Sorry, this one was sent before completed by mistake. Please refer to the next one.

http://www.sqlservercentral.com/Forums/Topic711107-145-1.aspx

Yep. Sorry. The first one was accidentally sent before being completed.

Thanks for your response. What I did not understand was what db resource was being taxed on when dealing with so many connections and how I can see it using...

I have:

Microsoft SQL Server 2005 - 9.00.3233.00 (X64) Mar 6 2008 21:58:47 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT...

Thanks all for your input! Have a nice weekend!

I ran profiler, but only captured 'sql:batch completed', I've tried locally as well as remotely, I ran into issues in either case. I hope running trace as a background job...

Either dynamic queries or stored procedures. Basically I would like to know what queries/procedures got run most on our production server. Using profiler for an extended period of time is...

Thanks Noel!

I know with sql 2005, it is the same for 'transactional replication with updatable subscription'. Do you know with sql 2008, does it allow schema change without loosing data...

Thanks to everyone who read my message and tried to figure out why.

Actually, I got the message during my first try, then I disabled the distribution cleanup job. Then...

sos_scheduler_yield is the wait type

I have not checked the wait type, I will take a look.

When I run it using my windows account, I am system admin, the sql account is not a sysadmin,...

Actually, I re-ran the query a few times with both authentication methods, with exactly the same execution plan, using windows auth does seem faster, about half of the time of...

Thanks, Luke. I was not exactly sure. The problem was reported by a developer. I just ran them side by side with either of the authen, they took roughly the...

Thanks for the reply!

The way I was thinking is to set up merge replication between A and B, then B and C, and then A and C. I dont have...

I ended up running update statistics on the table with full scan, then the new index no longer gets used by that query, therefore no bad execution plan.

Thanks Gail...