Viewing 15 posts - 1 through 15 (of 111 total)
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...
August 19, 2011 at 7:18 am
medicinformatics (5/16/2011)
May 16, 2011 at 8:28 am
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...
May 16, 2011 at 7:50 am
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?
May 3, 2011 at 10:55 am
jefydominic (4/29/2011)
DELL Power Edge server 2950
CPU - one quad intel processor 64Bit
RAM - 32GB
HBAs - 2 (Single Port...
April 29, 2011 at 5:56 pm
Google searching i found and this seems pretty good
April 28, 2011 at 4:50 pm
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...
April 27, 2011 at 7:15 pm
I got it working, this will not be my logging strategy, i just wanted to peek inside whats happening inside the Script component
April 27, 2011 at 4:09 pm
jefydominic (4/27/2011)
April 27, 2011 at 3:19 pm
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...
April 26, 2011 at 10:35 pm
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)
April 26, 2011 at 8:02 pm
jefydominic (4/26/2011)
CPU :- 2 Quad core processors - 64Bit,3GHz or more
Hard Disk :- 4 RAID Contollers (SCSI fiber channel) and 4 arrays
...
April 26, 2011 at 7:21 pm
Michael Valentine Jones (4/26/2011)
dant12 (4/26/2011)
April 26, 2011 at 3:40 pm
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...
April 26, 2011 at 3:01 pm
SQLRNNR (4/26/2011)
dant12 (4/26/2011)
April 26, 2011 at 2:32 pm
Viewing 15 posts - 1 through 15 (of 111 total)