See https://sqlserverfinebuild.codeplex.com/wikipage?title=Windows%20Memory%20Switches for suggestions of what switches you should use.

As Gail says, most of these settings only give a benefit in a small number of situations.

The UserVa value is only...

The image you show is 'standard' when you use high DPI settings within Windows 🙁

A Microsoft GUI is typically designed with fixed field lengths that are measured in...

It can be easy to get stuck in making sure that a process works, and lose sight of the reason you are doing the work.

In general eliminating fragmentation is a...

The Devs seem to be asking you to prove that the CPU hogs are a problem to SQL Server. I would try to turn that round, and get the...

I don't think I've seen a link to Ola's maintenance solution on this thread, so https://ola.hallengren.com/.

His processes are first-rate and regularly maintained to cope with new features and problems.

I think Steve is on the best track. You need to look at three things: 1) Total size of the objects you need to copy; 2) Rate of change...

Maybe we should stop thinking of employees as 'Resources' and start thinking of them as 'Domain Experts'.

All employees gain expertise of their work domain as they perform their jobs. ...

Are your database files hosted on Cluster Shared Volumes (CSV) or traditional cluster disks.

If they are on CSVs you should see no outage at failover. If they are on...

You do not get the space back because you are not blowing up a balloon.

A data file is a rigid container, not a flexible one. If you...

Jeff's reply + 1

Is TCP Offload disabled on the Hyper-V host and on all guest machines?

TCP offload was originally designed to improve performance by forcing the network adaptor to do some...

Before you do a shrink and a index defrag, ask yourself what has to happen while the index is running. Work through in your own mind what space is...

SQL Server is a great product, but the licensing cost of recent versions has forced us to loo at what else is on the market.

Amazon Redshift provides much the same...

You will also have to configure a port number for MSDTC via the ServerTcpPort registry key, as it does not have a default port. Google can find a lot...

Don't forget that SQL Server imposes the limit that a given table can only have one clustered index, but this limitation does not exist in all DBMSs. So when...