sqlrds.com
SQLRDS FAQ - Australia | by DBInsight
http://www.sqlrds.com/FAQ.html
How to Sign Up. Which SQLRDS to Choose. 1 What is SQLRDS? SQLRDS is a Relational Database Service for cloud based and on-premise SQL Server environments. SQLRDS implements a best practice framework for database administration, management and monitoring that prevents data loss and maximises your SQL Server's performance and system uptime. 2 Who provides SQLRDS? The SQLRDS service is provided by DBInsight Pty Ltd. A leading Australian based provider of SQL Server services to Corporate and Government clients.
roarsql.com
Memory | @RoarSQL
https://roarsql.com/category/sql-server-2014-2/database-engine/memory
The Ponderings of a SQL Server Consultant. Thinking of getting a bigger pool? July 23, 2015. SQL Server 2014 introduced us to a number of great new features, one that’s often overlooked but can quite easily improve the performance of read-heavy OLTP workloads, especially on resource constrained hardware, is Buffer Pool Extensions (BPE). ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION ON (FILENAME = 'E: MYBPEFolder MYBPEFile.BPE', SIZE = 50 GB);. As far as sizing is concerned, the maximum size suppor...
roarsql.com
buffer pool extensions | @RoarSQL
https://roarsql.com/tag/buffer-pool-extensions
The Ponderings of a SQL Server Consultant. Tag Archives: buffer pool extensions. Thinking of getting a bigger pool? July 23, 2015. SQL Server 2014 introduced us to a number of great new features, one that’s often overlooked but can quite easily improve the performance of read-heavy OLTP workloads, especially on resource constrained hardware, is Buffer Pool Extensions (BPE). ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION ON (FILENAME = 'E: MYBPEFolder MYBPEFile.BPE', SIZE = 50 GB);. As far as sizing...
roarsql.com
buffer cache | @RoarSQL
https://roarsql.com/tag/buffer-cache
The Ponderings of a SQL Server Consultant. Tag Archives: buffer cache. Thinking of getting a bigger pool? July 23, 2015. SQL Server 2014 introduced us to a number of great new features, one that’s often overlooked but can quite easily improve the performance of read-heavy OLTP workloads, especially on resource constrained hardware, is Buffer Pool Extensions (BPE). ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION ON (FILENAME = 'E: MYBPEFolder MYBPEFile.BPE', SIZE = 50 GB);. As far as sizing is concer...
roarsql.com
sql server | @RoarSQL
https://roarsql.com/tag/sql-server
The Ponderings of a SQL Server Consultant. Tag Archives: sql server. Backups having an image problem: VEEAM and SQL Log Truncation. August 17, 2015. Backing up and restoring databases from an image based recovery solution is very different to traditional SQL Server recovery methods, as I’ve found out with VEEAM Version 7. BACKUP LOG [Database Name] TO DISK = ‘NUL’. I queried the msdb.dbo.backupset table and found that the offending databases had no record of any backup ever occurring. Remembe...However t...
roarsql.com
rdbms | @RoarSQL
https://roarsql.com/tag/rdbms
The Ponderings of a SQL Server Consultant. Thinking of getting a bigger pool? July 23, 2015. SQL Server 2014 introduced us to a number of great new features, one that’s often overlooked but can quite easily improve the performance of read-heavy OLTP workloads, especially on resource constrained hardware, is Buffer Pool Extensions (BPE). ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION ON (FILENAME = 'E: MYBPEFolder MYBPEFile.BPE', SIZE = 50 GB);. As far as sizing is concerned, the maximum size suppor...
roarsql.com
Thinking of getting a bigger pool? | @RoarSQL
https://roarsql.com/2015/07/23/thinking-of-getting-a-bigger-pool
The Ponderings of a SQL Server Consultant. Thinking of getting a bigger pool? July 23, 2015. SQL Server 2014 introduced us to a number of great new features, one that’s often overlooked but can quite easily improve the performance of read-heavy OLTP workloads, especially on resource constrained hardware, is Buffer Pool Extensions (BPE). ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION ON (FILENAME = 'E: MYBPEFolder MYBPEFile.BPE', SIZE = 50 GB);. As far as sizing is concerned, the maximum size suppor...
roarsql.com
new feature | @RoarSQL
https://roarsql.com/tag/new-feature
The Ponderings of a SQL Server Consultant. Tag Archives: new feature. Thinking of getting a bigger pool? July 23, 2015. SQL Server 2014 introduced us to a number of great new features, one that’s often overlooked but can quite easily improve the performance of read-heavy OLTP workloads, especially on resource constrained hardware, is Buffer Pool Extensions (BPE). ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION ON (FILENAME = 'E: MYBPEFolder MYBPEFile.BPE', SIZE = 50 GB);. As far as sizing is concern...
roarsql.com
About | @RoarSQL
https://roarsql.com/about
The Ponderings of a SQL Server Consultant. I’m an experienced SQL Server professional who undertakes complex consulting engagements to maximise my client’s investments in their data assets. Specialising in SQL Server infrastructure architecture, performance tuning and configuration, I have a very high level of proficiency in designing and implementing complex SQL Server environments, troubleshooting and remediating performance issues, query writing and technical training. Leave a Reply Cancel reply.
roarsql.com
Welcome to RoarSQL | @RoarSQL
https://roarsql.com/2015/07/21/welcome-to-roarsql
The Ponderings of a SQL Server Consultant. July 21, 2015. Hi and welcome to RoarSQL! Firstly, let’s get the introductions out of the way, my name is Phil Jones and I’m based in Melbourne, Australia. I’m a Microsoft Certified SQL Server Professional and Trainer, specialising in SQL Server Database Engine and High Availability technologies. So what’s this all about? This entry was posted in Uncategorized. Thinking of getting a bigger pool? Leave a Reply Cancel reply. Enter your comment here. You are commen...
