3,860 reputation
817
bio website brentozar.com
location Chicago, IL
age 40
visits member for 5 years, 2 months
seen yesterday

I make SQL Servers faster and more reliable. I'm a Microsoft Certified Master and Microsoft MVP.

Stuff I'm proud of:


Nov
13
answered Google Wave vs Sharepoint
Nov
2
awarded  Enlightened
Oct
19
answered Should I disable Jumbo Packets on iSCSI network?
Jul
8
revised Google Chrome Enterprise - Any Gotchas?
Adding chrome-os tag for future use
Jul
8
comment Best RAID configuration for a Windows Server 2008 Hyper-V virtualization server?
To clarify - the question asked for the best, and RAID 10 is the best, so +1.
Jul
8
answered Connecting remotely to an SQL server inside a LAN
Jul
8
revised Connecting remotely to an SQL server inside a LAN
Fixing tags
Jul
3
comment Why is CPU use so asymmetric on our 8-cpu SQL Server box?
@Sean - you're saying that one particular large database would stick to one CPU? Seriously?
Jul
3
comment Why is CPU use so asymmetric on our 8-cpu SQL Server box?
Yeah, what you do is create extra new files on the filegroup. For example, if you want to end up with 4 files on the primary filegroup, then create another 4, and empty out the first one into the other 4 by using the DBCC SHRINKFILE command with the EMPTYFILE parameter, then delete that first file.
Jul
2
comment Why is CPU use so asymmetric on our 8-cpu SQL Server box?
I like this idea, but there's several databases involved that each have their own data file. I would expect it to be a little flatter given the number of databases. I still like it though.
Jul
2
comment Why is CPU use so asymmetric on our 8-cpu SQL Server box?
UZbones - don't you find it odd that some are averaging higher than others? 9% vs 21% is a pretty big variance. My concern would be that if the server's load continues to ramp up, that we'll hit a bottleneck earlier if the load isn't even.
Jul
2
comment Why is CPU use so asymmetric on our 8-cpu SQL Server box?
There's only one data file and one log file per database. Everything's in the primary filegroup.
Jul
2
answered Why is CPU use so asymmetric on our 8-cpu SQL Server box?
Jun
29
answered MS SQL server: Single or multiple instances?
Jun
26
awarded  Beta
Jun
18
answered Hide certain Error IDs in MS SQL logs
Jun
18
revised Hide certain Error IDs in MS SQL logs
Retagging mssql as sqlserver
Jun
18
answered Best way to benchmark linux virtualization solutions
Jun
18
comment How do I give access to SQL Server 2005 Reports for users outside domain without using FBA
Be really, really careful how much access rights you give. If someone drops an aspx page in your web server that drops databases, and if you gave the asp.net account enough permissions, it'll happen. This is hacker gold.
Jun
18
comment Upgrading SQL/TFS OS from 2003 Std to 2008 Enterprise - Is it safe?
He asked about the OS, not SQL version.