April 2, 2008 at 9:01 am
My company is looking at installing an Event Log Analyzer, which uses MySQL for the database. They also want to use the server I currently have SQL Server 2000 EE installed on. My SQL Server is a production server. Is this a bad idea or what?
glenn
April 2, 2008 at 9:08 am
Yes, it is a bad idea as SQL Server will have performance and stability problems if there are any other services that use significant resources.
Optimal is to have the server dedicated to SQL Server and to disable any un-needed services.
Who is the vendor of the Event Log Analyzer ? Do you have a URL ?
SQL = Scarcely Qualifies as a Language
April 2, 2008 at 9:43 am
This is the site for the software: http://manageengine.adventnet.com/products/eventlog/
I have since been informed by my manager that there is a version for MS SQL Server.
I just love getting piece meal information. Sorry for any confusion I created.
April 2, 2008 at 10:43 am
It won't necessarily cause performance problems. While I like dedicated SQL Servers, depending on the resource usage by SQL Server and by the other app, and your hardware, they can co-exist fine. If your SQL Server appears underutilized, CPU, Memory, etc, then this could work.
The bigger question is do you have MySQL skills? Can you manage that service? IF not, I'd look for the SQL Server version and just add another database.
April 2, 2008 at 10:53 am
"This is the site for the software: http://manageengine.adventnet.com/products/eventlog/
I have since been informed by my manager that there is a version for MS SQL Server.
"
Great -
You should be very concerned about capacity. The client I am working at has about 700 SQL Servers and thousands of application and file servers. One month's of Windows event logs uses over 200Gb of SQL Server disk space and is on a dedicated 4 CPU server. When Reporting or Analysis runs, all 4 CPUs go to 100% and the disk drives are also at 100% utilization.
You need to run some benchmarks to determine an appropriate architecture.
SQL = Scarcely Qualifies as a Language
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply