The profiler counter gives you submitted batches and that may not be single transactions. It is a good indicator though. Just realize if you use profiler to try and capure...

If you find that you are using fibre mode for a shortage of threads you can always increase the amount of workerthreads. If you are using it to cut down...

Polyserve uses a diffrent type of clusering SQL UP does as well. sql 2005 offers database mirroring that could replace clustering as well.

Wes

Kill all the users out of the database before altering it into single user mode, here is a sample:

----------------------------------------------------------------------------------------------------------

--Kill all users out of a database--

--set the @dbname var to the...

More files allows windows to spawn additonal threads to do I/O on them. Are they needed in your situation? I can't answer that. Second, yes you can merge the .ndf...

Start with the article for sure. If this is a cluster you will have to start DTC on the windows 2003 server before SQL comes online this is a known...

You may try forcing TCP instead of named pipes its been so long since I've had to work with sql 7 I'm not sure where the settings are.

WEs

if you are using windows authintication this is the simplest setup possible.

on the general tab under type check sql server

on the security tab

check "be made using logins current security...

Deadlocks are simple to explain and usually complex to fix.

the issue is table A is needed for a transaction by thread 1. thread 2 starts and grabs table b...

You cannot trap just delete activity from profiler. If you are planning to run this long term I would suggest a tool like entegra from Lumigent that won't have the...

I think I get it now. You are trying to make sure that you are assured of a full backup every 8 hours no matter what. It still seems like...

When you do a full it does a trans log backup at the end and apends it to the actuall full. A diff does not do a tlog backup and...

Same here. I won't have a ready script until the end of this week or beginning of next. When it is done it will go into the script library here....

Well the Distributed Transaction Coordinator controls the transaction and if it can't start or there is an error it will display in the Query Analyzer window. Can you put the...

My reindexing script looks at the log between tables and will perform a tlog backup if needed is currently in testing. We blow up the tlog doing a index defrag....