Depending on the kind of service you provide, I can see the value in that letting your geek users know how your server fares. If i notice my favorite service/server...

medicinformatics (5/16/2011)

---

Can we just replace the master database and log files with a good backup, instead of running setup with rebuild option? I did that with SQL2005, would that...

Good read, i have seen the WMI error previously but since it were inside a testing VM i just reverted the to prior snapshot, now i know how to fix...

It depends.

What is the usual load on your database? Is it mainly OLTP or mainly reporting? What is the usual load? Average amount of data changed per day?

jefydominic (4/29/2011)

---

I have taken hardware configuration from DELL SQL Advisor, It is given below.

DELL Power Edge server 2950

CPU - one quad intel processor 64Bit

RAM - 32GB

HBAs - 2 (Single Port...

Google searching i found and this seems pretty good

what he meant was to leave the database transaction log together with the database data files. the idea behind splitting those is improving DML (insert,update,delete) performance.

since your load will...

I got it working, this will not be my logging strategy, i just wanted to peek inside whats happening inside the Script component

jefydominic (4/27/2011)

---

We dont have any buchmark system. Right now we have loaded this 100GB data in a Testing SQL server, its configuration is 4GB RAM, one Dual core processor 2...

the more the merrier, I always say!

Also, to get this clear since the op mentioned 2TB drives, it is also better to have more disks with fewer bytes per disk...

Agreed

The usual "depends" apply perfectly here.

Must always keep in mind RAID 5 is not best suited for heavy write operations (such as tempdb and transaction logs)

jefydominic (4/26/2011)

---

Please review following revised hardware configuration.

CPU :- 2 Quad core processors - 64Bit,3GHz or more

Hard Disk :- 4 RAID Contollers (SCSI fiber channel) and 4 arrays

...

Michael Valentine Jones (4/26/2011)

---

dant12 (4/26/2011)

---

depending on the fill factor settings and table load, indexes can take awhile to actually get fragmented. getting an actual percentage of rows not currently compressed...

depending on the fill factor settings and table load, indexes can take awhile to actually get fragmented. getting an actual percentage of rows not currently compressed can factor in the...

SQLRNNR (4/26/2011)

---

dant12 (4/26/2011)

---

Reading through this http://msdn.microsoft.com/en-us/library/dd894051%28v=sql.100%29.aspx SQLCAT post, it is stated that under certain condititions a row in a PAGE COMPRESSED table can be ROW COMPRESSED instead of actually PAGE...