I'm with Raj. Unless you are deploying changes daily, I'd say that real-time is a bad idea. Even using QA for standby doesn't work since you can't "trust" the data...

There is some overhead to measuring the counters and logging them. If you have the graphical display up, this uses overhead as well.

you can use Task Manager to get an...

A particular SPID typically is on one connection. A user can be connected many times, but each process has it's own ID.

SPIDs are reused, so you can see them in...

Can you explain what you mean? Do you mean statistical standard deviations? there are functions for this.

Set up logging for the package, and then use the logging provider to point to a table.

Moved to the SSIS forum.

You want to keep free space in the files. That is what is used as the server needs to allocate space for inserts/deletes. This is expensive, and you don't want...

What are you looking to monitor? There's a whole range of things here.

sqlSentry has a good performance monitoring tool.

Quest has some tools, can be expensive

Idera has a variety of tools...

I like Diff backups if you can do them because they speed and simplify restores. I have run them every 2-6 hours at times to ensure that I don't have...

I agree with Robert. Portability doesn't mean writing the lowest common denominator. The code shouldn't be lifted from one platform and dropped on another. It should be slightly altered to...

I'm not sure about the removing features, but there are quite a few little things that would make life easier, and they're not usually important enough for someone to write...

I'll move this to the strategies forum.

The way I'd do this is in stages. First I'd get mail working. Look up Database Mail, get that setup and tested.

Next, I'd create...

Hey, I'm starting to resemble that remark. :w00t:

Likely the issue is the Dynamics user doesn't have rights to create the user. You are having database issues.

What you might want to do if you sort out rights is...

Jerry has some good ideas. I'd dig into and see if the procedures that you are looking at have additional parameters. Some do which might help in cases. This one...

Please don't use polls to ask questions.