My rule of thumb: If you're modifying a large portion (say, more than 10 percent) of your table, do a full population rather than an incremental one. That's why I recommend you enable change tracking with background or scheduled updating. If you do, you'll see that MSSearch will...
Although the purpose of the paper is not to provide an installation tutorial, it will be useful to refer to Figure 1, which is the first dialogue of the “Configure Management Data Warehouse” Wizard. The wizard is accessed from SQL Server Management Studio by right-clicking on the “Data C...
OK so max server memory at 2PB, that's the default setting, so yes I would recommend you change this to a suitable value. Generally the rule of thumb is leave 10% to the OS, but this is a generalised rule, your preferred settings may be more, or less to leave. ...
As a best practice, a rule of thumb is to:· Compress your fact tables by using the PAGE compression feature [Agar08].· Add enough memory to your system so that at least 10-20% of the compressed data will fit.Compression is not free. Its main cost is the increased CPU time ...
Set Pre-size to 8GB/2GB as a minimum. 20-30% of the database file size is a rule of thumb. Set Auto-grow to 500/100 as a minimum. This information does not apply to System Center 2012 Configuration Manager. For those system requirements, seeSupported Configurations for Configuration Manag...
The latency counters are measured in milliseconds. A reading of 0.001 is one millisecond, 0.010 is ten ms, and .100 is a measure of 100 ms. Good and bad latency changes depending on many factors (these factors are way beyond the scope of this post). A good rule of thumb is latency ...
A good rule of thumb is if there are less than 1 million images, or if there are big images (greater than 1MB), put them in the file system. For more than 1 million images of sizes less than 1MB, put them in SQL Server. For everything in between, either way will work; you just...
I will discuss how to fine-tune the number of data files in tempdb in Chapter 9, but you can use the following as a rule of thumb in the initial configuration: If the server has eight or fewer CPU cores, create the same number of data files. If the server has more than eight CPU...
As a rule of thumb it is always best to resolve the resource wait that represents the greatest proportion of overall wait time before proceeding with more in-depth analysis.Analyzing current wait buffer latchesBuffer latch contention manifests as an increase in wait times for latches with a ...
(CAST (value_in_use AS INT)/1024/4)*300 FROM sys.configurations WHERE NAME = 'max server memory (mb)' If this is correct then determining the appropriate PLE is actually very straightforward (although I imagine this is only a rule of thumb): you basically use the MS figure of 300 fo...