AnsweredAssumed Answered

How to interpret SQL Server recommendations in Turbonomic

Question asked by pallentx on Oct 11, 2019

I get the recommendation to size memory up or down, but can you provide some guidance on how to respond to recommendations to scale up or down connections or increase the transaction log. Each database has a transaction log, but the recommendation just gives me a server name. Also, SQL Server will automatically increase transaction log files as needed. I get that you can avoid resize operations, but these files sizes are generally static unless there's a runaway query that runs it up suddenly. A size down on transaction logs could be helpful if an odd query ran it up, or it was initially sized to big and the database hasn't needed that much log space again. 

If you have some documentation I've missed, or some guidance on how to respond to these recommendations, I would appreciate it. 

Thanks. 

Outcomes