1. Here they are:
OS Name Microsoft(R) Windows(R) Server 2003, Enterprise Edition
Version 5.2.3790 Service Pack 2 Build 3790
System Manufacturer Intel
System Model S5000PAL
System Type X86-based PC
Processor x86 Family 15 Model 6 Stepping 4 GenuineIntel ~2992 Mhz - 8*Xeon
Total Physical Memory 6 137,80 MB
Available Physical Memory 297,45 MB
Total Virtual Memory 7,81 GB
Available Virtual Memory 2,35 GB
Page File Space 2,00 GB
Page File C:\pagefile.sys
All database file are placed on non-system disk e:\ which uses 7-disks RAID 5 (Fibre-channel 4 gbit).
I wonder what does it mean: tempdb layout? Please explain in more detail.
2. As i've understood correctly, should i run 'DBCC CHECKIDENT'?
3. I find a delicious KB-article which helps me to understand what to monitor in profiler.
4. Unfortunately, i couldn't find this in MS KB. Could you help me with this script?