August 12, 2015 at 2:45 pm
Hi all,
We have just had budgets released to improve our database estate infrastructure, and have run Brent Ozar's Blitz audit script. I'm fully aware on best practices with servers and databases, but would like ideas on best practices for SQL environments regarding;
Vlan;
Firewall;
ESX;
Load balancing.
Failover;
Own rack
Current setup
6 server architecture with service provider:
2 User data servers, each db 50gb (100gb total)
4 Sproc (processing) servers
1 Reports server
All 2008 R2
Token-based VM machines
Current+Future SLA - downtime only permitted 5-9 Sat/Sun
+ Local environment, stripped down version of above on a workgroup (to be migrated to domain)
Would appreciate any guidance esp. what questions need to be asked.
Thanks!
August 14, 2015 at 3:27 pm
The single biggest SQL tuning payback, after any infrastructure issues are addressed, is making sure you have the best clustered index on every significant table. Hint: This is most often NOT an identity column.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply