149 reputation
4
bio website
location
age
visits member for 3 years, 4 months
seen Mar 18 at 14:53

Jun
29
asked Hidden mounted drive
May
10
awarded  Scholar
May
10
accepted Scale a highly transactional SQL server
May
10
accepted Windows Updates On Single Production Web Server
May
10
accepted Optimal Ethernet speed for dedicated web server 100Mbps vs. 1000Mbps
May
10
accepted Max RAM in Windows Server R2
May
6
awarded  Supporter
May
6
asked Max RAM in Windows Server R2
May
4
awarded  Commentator
May
4
comment Scale a highly transactional SQL server
Hi SuperCoolMoss, have a large proportion of writelog waits in SQL as well as other IO related waits. And can see that the disks are pretty much maxed out by looking at the relevant IO related performance counters directly on the server.
Apr
27
asked Windows Updates On Single Production Web Server
Apr
25
comment Scale a highly transactional SQL server
Hmmm, I never knew that.. I thought checkpoint occurred after each commit..? Thanks, appreciate the info..
Apr
25
comment Scale a highly transactional SQL server
Correct, but I think that's not really relevant. Most of our transactions affect single rows. So each update/insert/delete is effectively checkpointed directly after it occurs. In effect each write affects both the transaction log, the data files, and the index files as they occur. But, I think we're getting a little off-topic here...
Apr
25
comment Scale a highly transactional SQL server
Hi, all writes will hit the disk, only reads can be serviced entirely from memory. The app is highly transactional, hence lot's of reads and writes..
Apr
25
comment Scale a highly transactional SQL server
Hi mrdenny, I can provide all that info but I didn't want to increase the scope of the question too much. 128Gb RAM, all indexes fully in RAM. More Read than Write (about 10:1). I'm guessing with the higher read RAID 10 will be better as reads will be distributed..?
Apr
25
awarded  Student
Apr
24
comment Optimal Ethernet speed for dedicated web server 100Mbps vs. 1000Mbps
Yeah, it is still pretty low performance, we only do 10m views a month currently. We run on three servers at the moment, all with 1Gbps NIC's.. Decided to scale up rather than out now, hence the move to one bigger server. Just wanted some practical experience around 100Mbps vs 1000Mbps. Faster does not always mean better..
Apr
24
comment Optimal Ethernet speed for dedicated web server 100Mbps vs. 1000Mbps
Thanks, it's the only server..
Apr
24
comment Optimal Ethernet speed for dedicated web server 100Mbps vs. 1000Mbps
Thanks, 500k pageviews a day currently. Average page size 50k. Of course, a 1Mbps connection could serve that.. ;-) I'm more looking from the perspective of provider bandwidth.. Many providers still only provide 100Mbps connections and charge for faster cards..
Apr
24
comment Scale a highly transactional SQL server
Thanks Greg, that's a great suggestion..! I've never thought of putting indexes on to their own SSD disks. That would be great for some of the indexes that get updated a lot..