Hi, we have an ECM web-based application that has a SQL database backend. I'm not a dba and my customer does not have a dba on staff. We believe there are performance problems stemming from the db, I'm not sure if it's server resources or the SQL configuration.
Does anyone have a good reference for SQL configuration so I can ensure it's configured in the most appropriate manner?
This is a single SQL server, no cluster. Server 2008 R2 with SQL 2008 R2. It's virtual (vmware) with 18 gb mem, 12 cpu cores.
Also, is using the Best Practice Analyzer a worthwhile exercise?
Thanks in advance.