In the same batch they both show 50% each.

I/O Stats wise please see new attachment.

Take more frequent transaction log backups and then find the sweet spot for size. e.g. After 2 hours of work it is 10gb so size it to 12gb and keep...

I also installed Sybase SQL Advantage 12.5.1 to get better drivers.

Mirroring can be expensive. It depends on what latency your business can live with.

In Finance it tends to be < 5 ms as loosing your primary business / trading platform...

I'd suggest setting 'lock pages in memory' against the account which is running the SQL services by using GPedit.

Now....

Who has the biggest Pork Chop Cannon?

Jeff perhaps?

Yes you can do all the things you asked and so much more.

I use the Idera Mobile Monitor on my Blackberry and it works a treat. Real time graphs, statistics, spid information and the ability to execute queries. The only downside is...

Final 2 cents worth is that you cannot restore a SQL 2008 R2 database onto SQL 2008 which I think is a fun one.

The above is 100% correct.

No Kerberos = No double hop.

You set the SPN for each server and deletegate to the common account and off you go.

Fell foul of this one ourselves and ended up deciding to set the directory paths to be identical so we don't get caught again in the future.

Couldn't agree more Steve.

"Anyone doing a backup/restore with SSMS wizzard will have a (very) bad point (unless he uses it just to generate the script, then he's lazy -> good point)."

What is wrong...

Hi,

Using Idera Diagnostic Manager 6.2 for our production clusters and works a treat. Users ask 'What queries were running at 3am and what was the server load' and we can...

I have exactly the same issue. I only want to restore the primary partition (10gb) and not the whole 200gb database spread across multiple filegroups.

It doesn't seem to be possible...