Hi there

Actually, its nothing to do with performance, unless your talking "cutover" performance? on server failure. Only one server at any one time can accept and process connections and...

Hi

Just ran some tests in COM+.

I wrappered two calls to stored procs, one did the updlock hint over a 10row table and the other proc had the waitfor in it....

Thanks for the post Joe...

Cheers

Ck

Hi

Why dont you do a simple test? 🙂

COM+ uses a isolation mode of serialisable, I would expect the locks to be held in context of the whole transaction. It...

Hi

Query the tempdb over a period of time in which performance is suffering to better gauge what is happening. Also, now are they being created, static cursors? have you...

Run Profiler, and check the events and columns carefully.

Cheers

Ck

Found it!

EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject', 'AD Provider'

grant select on corpsysad_allusers to public

select * from corpsysad_allusers

create view corpsysad_allusers as

SELECT name

FROM OPENQUERY( ADSI, '

...

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q251/1/95.ASP&NoWebContent=1

not really what your after but worth a good look.

Hi

I did this via a linked server, see the BOL, they have an example. Unfortunatly I blew away the link and for the life of me cant remember the...

Hi

Run perfmon.exe, any counters exist for your instance?

I would say no, or if they are there, they are returning no values.

Search for previous posts on resolving this if that is...

Hi Victor

Excellent article and very well thought out scripts with examples.

Cheers

Ck

Hi Antares686

I think not, it gives a warning only and says y"ou better consider this very carefully blah blah", checking the logs it doesnt seem to issue the command altering...

Hi

Im not sure you can! take a look at the affinity options for CPU alloc in sql server, you can set it up in such a way (from memory here)...

Hi all

Yep, had this problem too, it was a fresh install of sqkserver 2k ee then sp3, i didnt check if it was sp3 though (unfortunatly) and I didnt have...

Hi Steve

Sorry Steve, I wouldnt write this sort of article unless you really delve into the underlying features of DB2 etc and do a side by side comparison. You'll...