Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raguyazhin
Posting Yak Master
105 Posts |
 Posted - 2011-12-12 : 01:39:18
|
| Hi I am working as a junior SQL Server DBA in small Industry. We have only two servers one for prodution and another one for reporting purpose.my some friends in other big companies they told we are maintaing 2000 sql sql servers and more.still i didn,t know why they want this much servers.and how its connected. how these all servers maintained like performance problems,backups,replication etc. lot of SQL Server genious in front of monitors,please help me to unterstand the setups models in industries.--Ragu |
|
|
pnash
Starting Member
26 Posts |
Posted - 2011-12-13 : 05:54:27
|
| why they want this much servers. - Directly proportional to Business need- various different type of applications and their data management- total number users that will connect SQL server- Performance prospective and storagehow these all servers maintained like performance problems,backups,replication etc ?-In larger organization everything implemented with proper planning and analysis. They follow their standards with respect to licensing, installation, Configuration Administration and support model.They use enterprise level tools (Tivoli , BMC, Liespeed)to monitor and manage the Sql servers. and Distributes the Roles and responsibility among the teams like monitoring team,production team, deployment team all this comes under hierarchy of SQL server support model. which ultimately very easy to support large number of server with less headcount. |
 |
|
|
raguyazhin
Posting Yak Master
105 Posts |
Posted - 2011-12-13 : 07:15:49
|
quote:
Originally posted by pnash
why they want this much servers. - Directly proportional to Business need- various different type of applications and their data management- total number users that will connect SQL server- Performance prospective and storagehow these all servers maintained like performance problems,backups,replication etc ?-In larger organization everything implemented with proper planning and analysis. They follow their standards with respect to licensing, installation, Configuration Administration and support model.They use enterprise level tools (Tivoli , BMC, Liespeed)to monitor and manage the Sql servers. and Distributes the Roles and responsibility among the teams like monitoring team,production team, deployment team all this comes under hierarchy of SQL server support model. which ultimately very easy to support large number of server with less headcount.
Thanks pnash--Ragu |
|
|
|
|
|
|
|
|
SQL Server Infrastucture