Your SQL Servers Are Misconfigured...

Question

Your SQL Servers Are Misconfigured...

Kevin3NF

SSCarpal Tunnel

Points: 4765
More actions
October 31, 2018 at 9:17 pm

#372643

Comments posted to this topic are about the item Your SQL Servers Are Misconfigured...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NF DallasDBAs.com/Blog Why is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

BeatleBoy SSC Veteran Points: 251 More actions · Answer 1

Hi Kevin,

I'd be interested in one of your free health check sessions. Let me know how I can better get in touch with you regarding that.

Thanks in advance!
Sean Pinto

willsit Grasshopper Points: 21 More actions · Answer 2

willsit

Grasshopper

Points: 21

November 1, 2018 at 12:20 am

#2011998

Is there any way you could share those scripts?

melissa.fischer 30767 Grasshopper Points: 22 More actions · Answer 3

Kevin I'm interested in your health check, please contact me.

Kevin3NF SSCarpal Tunnel Points: 4765 More actions · Answer 4

For those interested in the HealthCheck offer, please email Kevin@DallasDBAs.com

More about us:
http://dallasdbas.com/about/

------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NF DallasDBAs.com/Blog Why is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]

alexandre.jobin Old Hand Points: 346 More actions · Answer 5

Since that you can't offert your services outside USA, is it possible to get your healtcheck script?

Kevin3NF SSCarpal Tunnel Points: 4765 More actions · Answer 6

alexandre.jobin - Thursday, November 1, 2018 7:05 AM
Since that you can't offert your services outside USA, is it possible to get your healtcheck script?

One of the 15+ scripts I run is sp_blitz from Brentozar.com

The rest are things that I have compiled over 18+ years, so I don't give them out as part of the free offering, sorry. Almost all of them are based on the SQL Server DMVs...just in meaningful ways. The biggest part of the health check is seeing all of the results and how they relate to each other. "Change this setting, and watch these numbers here get better".

Hope that helps!

------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NF DallasDBAs.com/Blog Why is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]

wesv Grasshopper Points: 24 More actions · Answer 7

Please let me know how I can work with you on the health check scripts. I have a server I would like to test.

jared.brown SSC Rookie Points: 30 More actions · Answer 8

Nice post Kevin. Don't forget that SQL Server 2008 & 2008 R2 are approaching End-of-Support this coming July. Probably worth a quick mention that Microsoft is offering customers an option to move those 2008 instances as is to Azure with three additional years of support for free.

todd.wenzel SSC Rookie Points: 27 More actions · Answer 9

I'm interested in the Remote DBA service you mention

gdonufrio SSC Veteran Points: 240 More actions · Answer 10

I'm interested in the Remote DBA service you mention and furthermore more services, please contact me if your available please contact me at gabriele.donufrio at enerj.it

Kevin3NF SSCarpal Tunnel Points: 4765 More actions · Answer 11

All,

SSC republished this article today, but the Free HealthCheck offer expired a long time ago. There is a $500 pre-paid option available:

SQL Server HealthCheck

Thanks,

Kevin

------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NF DallasDBAs.com/Blog Why is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]

martindnovak SSC Rookie Points: 47 More actions · Answer 12

Set Max Server Memory – I leave some memory for the O/S that SQL can’t touch. This is also in the Instance Properties.

So what value do you actually set the Maximum server memory (in MB) to? It defaults to 2147483647.

Thanks

Martin

Kevin3NF SSCarpal Tunnel Points: 4765 More actions · Answer 13

martindnovak wrote:

So what value do you actually set the Maximum server memory (in MB) to? It defaults to 2147483647.

Typically, I leave 10% or 4GB for the O/S. More if there is clustering or multiple instances, or other applications involved.

------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NF DallasDBAs.com/Blog Why is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]