guessed as much. sorry no experience. I'd try resources and maybe perfmon.

try dropping from this menu

http://www.grumpyolddba.co.uk/Infrastructure/Infrastructure.htm

it has details of the tests I've been using. Sadly I cannot name the san I've been testing. shared luns are a problem,...

you'll also need experience with systems, something which will only come with time. This isn't something you can learn from a few links and blog posts.

I'd suggest you purchase...

sorry can you clarify TFS for me? I'd check the usual suspects, memory, cpu, disk access, disk latency.

although technically with 8gb of ram you might expect a 2gb db to be in buffer cache you might actually be surprised how buffer cache gets used by sql server....

if you go to my web site http://www.grumpyolddba.co.uk/monitoring/Creating%20Custom%20Reports%20for%20the%20DBA.htm

there's an rdl that will show blocking sessions, there's a couple of other rdls that may help by the sounds of things!!...

only if you haven't been using the san I've been testing!!!!

Regardless of x64/x32 you must leave adequate memory for the o/s. Despite your db only being 3GB, memory is also used by master. msdb, tempdb and system resource dbs. Believe...

Partitioning is the only way to handle big databases but do consider the increased admin overhead in managing all those files, filegroups and partitions!

Yup it's enterprise only, I have ...

You also mentioned raid 6, I don't think you could possibly have a worse raid level for writes; 2 parity disks; you might as well use a floppy and I'd...

are you trying to create a snapshot or was that the error raised from checkdb on msdb ?

Ah but you have the classic combination for poor performance, VM + SAN.

Monitor the io completion latency in perfmon .. Avg Disk sec/write , Avg Disk sec/read for each...

well I wouldn't worry too much about what your monitoring tool says!! If you've set the memory for sql server correctly then memory should be good. You ideally don't want...

see what a hornets nest this stirs up. I'm pretty sure iscsi sans work on 1gb ethernet, that's going to be one hell of a bottleneck. all luns across all...

Ah don't you just love vendors!! I can tell you of a BI vendor who set a DW database to binary collation ( case sensitive for our readers )...