104 reputation
5
bio website sqlwebpedia.com
location Seattle, WA
age 42
visits member for 5 years, 2 months
seen Jul 8 '13 at 16:34
SQL Server Administrator, entrepreneur, family man, Christian. @SQLGuyChuck on twitter.

Feb
6
comment MSMQ very slow to receive messages
Just the chattiness of the messages. They also found some authentication miss configurations.
Feb
6
answered MSMQ very slow to receive messages
Jan
9
answered Restore SQL Server database to new server and spilt primary to file groups?
Jan
9
answered How do I spec new storage performance requirements based on current data?
Jan
9
answered SQL2008 Won't Work After SP1 Install?
Jun
30
answered Migrating an Access Database into SharePoint 2007
Jun
30
answered Recovering a specific job definition from an MSDB backup?
Jun
30
awarded  Supporter
Jun
17
comment Windows 2008 IO Testing for SQL
OLTP, but used in reporting fashion often no ad-hoc though, just dynamic procs. 550 max trans/sec Cache hit is about 98% avg 90 on low marker. Reads/Writes average is 50/50 peak is 500/300 per second. Disk queue peaks to 80 (on shared SAN though).
Jun
17
comment Windows 2008 IO Testing for SQL
I have 16GB RAM. We tried IOMeter with 1,000,000 sectors and it reported something like 4000 Iops. We have just been burned previously with shared SAN on VMWare, two bad combinations, with tons of IO slowness. I want to get a better handle on these dedicated boxes IO capability so I can go to our SE's and say in the future we tested at max IO x we are using IO y now and growth is showing we will run out IO in x days. Basically evidence that I need more spindles or some other solution. Or am I going about this wrong?
Jun
17
comment Windows 2008 IO Testing for SQL
It is local disk, so I don't have any special software to see what disk are really doing. I worry that windows 2008 is doing its new improved caching capability, but distorting the SQLIO tests. I have read elsewhere that people have worked around, but I don't know how they did it.
Jun
17
comment Windows 2008 IO Testing for SQL
I am trying to get a baseline of server performance before I turn the box live. My 40gb database can't all be in cache so I want to eliminate its effects. So, when it is running I get baseline of IO under normal use and know how much headroom I have for growth.
Jun
17
asked Windows 2008 IO Testing for SQL
Jun
14
answered Reinstall Reporting Services 2005
Jun
11
answered Troubleshooting IIS to SQL 2005 connection issues in complex environment
Jun
11
revised Troubleshooting IIS to SQL 2005 connection issues in complex environment
partial solution found
May
29
comment Troubleshooting IIS to SQL 2005 connection issues in complex environment
Yep, I just haven't had the time to investigate deeper. I suspect SPN's just aren't getting created correctly or at all.
May
29
comment Troubleshooting IIS to SQL 2005 connection issues in complex environment
We even had a Microsoft consulting team person on site to help and found issues that we resolved and did a bunch of tcpip testing with packet sizes. I am just looking for literature and testing methodologies like your ping test idea. I documented our tcpip tweaks here: sqlwebpedia.com/content/tcp-optimization-windows
May
28
awarded  Student
May
28
asked Troubleshooting IIS to SQL 2005 connection issues in complex environment