Viewing 15 posts - 1,381 through 1,395 (of 2,497 total)
It is a good idea to give the DBA group full control rights on all folders containing database files, database backups, SQL Server binaries, etc.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 6, 2009 at 4:45 am
The best practice is to create a Windows group to hold all the DBA accounts. Grant this group login rights to SQL Server and add it to the Sysadmin...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 6, 2009 at 2:47 am
The SQL Server 2008 install even has an option to specify where you want tempdb to be placed, so you can separate it from your other databases at install time.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 6, 2009 at 2:29 am
Ed what fix are you refering to?
Apologies, I got my SQL versions mixed up. However, there are fixes for AWE issues post SP2, but nothing that is pervasive.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 3, 2009 at 9:32 am
Try asking for less memory when you start SQL Server. If you ask for more AWE memory than what is available to don't get any of it.
Also make sure...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 3, 2009 at 8:13 am
Some tests done where I work now show about a 5% penalty time and CPU penality in using Litespeed encryption, but backup size is has less than 1% difference, compared...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 3, 2009 at 8:10 am
Total Server Memory for the SQL counter still shows 1.6GB
Did you see the bit in my post about Task Manager not showing memory use above the 4GB line? ...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 3, 2009 at 7:44 am
The Windows Task Manager on a 32-bit server only ever knows about memory use below the 4GB line, so it will never show you how much AWE memory is in...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 3, 2009 at 3:34 am
I agree with Michael.
In the early days of databases, IMS got man to the moon in a hierachical fashion. IMS is still around and scales to any size you...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 3, 2009 at 3:02 am
I think my results and rudy's results show that backup performance is affected by how your server is configured. You probably need to try various options and find the...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 3, 2009 at 2:24 am
This use to be an issue on SQL 2000 - but, it has been fixed in 2005.
Jeffrey - thanks for the update, I had missed that one!
Krishna, ...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 3, 2009 at 2:21 am
Or 6-core processors, and shortly there will be 8-core procesors. SQL is licensed by number of CPU sockets, not number of cores.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 2, 2009 at 7:11 am
You need to look at your recovery SLAs when you plan your backup strategy. The main point in taking a backup is to be able to do a recovery,...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 2, 2009 at 7:08 am
At my old place I once did a test with Litespeed on a c 300 GB DB. I don't have the exact figures, but when backing up to 1...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 2, 2009 at 6:59 am
I tend to istall the DTS Designer components on a new build after applying any SPs and CUs. But then a new SP or CU comes along and it...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 2, 2009 at 6:32 am
Viewing 15 posts - 1,381 through 1,395 (of 2,497 total)