(imported topic written by gcibirch91)
Hi,
We have now increased our Bigfix client installations and I am worried that the SQL Server will be getting hammered. Is it possible to set up replication to another server in a different country? Would this increase the speed of the console opening??
Thanks
Lee
(imported comment written by gcibirch91)
Hi
We have licence maximum of 700 and I reckon we get to about 500 globally. When we initially did the install we was only looking at servers only.
The reason I am looking at replication is that when I open the console on my computer based in UK, it takes an absolute age to load up because the database is in the US.
Lee
(imported comment written by StacyLee)
That sounds more likely the WAN link is your bottleneck. You are essentially making a DB connection from your console to the BES server in the US, the load data loading to your console can take some time depending on amount of data and changes since your last logon.
500-700 clients are easily handled by 1 BES server. Depending on what machines you manage globally (all or subset) you want to consider setting up a server for Terminal services in the US located in the same datacenter as your BES Server and installing the BES Console there. RDP to that machines then launch the console from there.
If you have console operators in the US you can ask them to see if they have the same slowness as you.
If no then it is probably the WAN link…
If Yes then there
could
be some server side issues to look at but SQL server replication will probably not solve your problem from a console performance loadng standpoint. Things to look at would be SQL peformance (shared with other DBs, local or remote DB, disk performance, etc)
If you only manage machines in the UK or immidiate area another option to look at is DSA (distributed Server Architecture).
(imported comment written by Luz91)
MY services of MSSQLServer start before that the BES services. So, the services MSSQLServer present the status of disconnecting from database; Will reconnect in10 seconds, this situation present in many times ago. Connect and disconnect the database and repeat the same situation. I create the dependencies of MSSQLServer Services, but present other errors. When write the value data to the dependencies and change other different value data, present different errors.
What order have use? Help me please
Luz
(imported comment written by BenKus)
Hey Luz,
The BigFix services will tolerate the errors with no ill side-effects if SQL Server starts after them so there isn’t any need for service dependencies.
Ben