We've never found any software that could do the trick, so we made a repository DB with all the info we could gather.

We try to make all the info gathering...

You can try to shrink it as much as you want, but since it's tempdb it might not always work (or only partialy shrink).

The best way to handle tempdb is...

Yep, the cluster service (or sql install) will try to create the names if they don't already exists.

You could use the Merge replication.

Doing all this by hand is not really the easiest thing in the world 🙂

Yes, you can see how many IO you are using right now.

If you can test that on a DB server already running you would already have a good idea of...

If the cluster service account has the rights to add computer name in the DC then it'll be added during the install (or when you create the cluster ressource for...

Well if you include the start date in the group by, it'll output a row per different start date.

So it's working the way it's supposed to work ...

To resolve your...

You don't take decision based on a single SQLIO, it works the other way around, you have expectation (xxx IO/s or xxx MB/s) and you use SQLIO to make sure...

If you setup your replication to be initialized, the replication will take care of transfering all the data before starting to replicate transactions.

So you don't have anything to do to...

The error 5 is an access denied, that means the service account running sql server doesn't have the right to write on the share or you forgot to specify a...

Could you give a shot at IOMeter on your previous disks and your new SSD to see the differences?

Only test for 8K and 64K packet, read and write, sequential and...

You are missing a quote somewhere.

You are trying to use Totalhours and EmpNo in a SET @query = . It can only work inside quotes since your FROM TestTable...

The problem is the SIZE=200GB, the backup command only backup the used pages and not the free space (that's why your backup is only 10MB).

When you restore, the first thing...

What other step do you have in your maintenance plan?

Any shrink?

What is the size of the index?

No need to cross post 🙂

http://www.sqlservercentral.com/Forums/Topic435492-149-1.aspx