Infrastructure at your Service

dbi services BLOG

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

Franck Pachot

ODA X-6 log file sync with NVMe flash

By | Database Administration & Monitoring | 3 Comments
 

 The new ODA X-6 has been announced last month with two smaller configurations and smaller prices: 2S and 2M. Small, but high performance configuration: all SSD, and I/O transfer optimized for Flash with PCIe bus and NVMe protocol. Let’s see how it keeps up with an high OLTP workload. Thanks to Arrow Oracle Authorized Solution Center to let us evaluate performance on their ODA.

Read More
David Barbarin

SQL Server AlwaysOn: new services packs and new diagnostic capabilities

By | Database Administration & Monitoring | No Comments
 

 As you certainly know, the SQL Server 2014 SP2 has been released by Microsoft with some interesting improvements that concern SQL Server AlwaysOn and availability groups feature. In fact, all of them are also included into SQL Server 2012 SP3 and SQL Server 2016. Among all fixes and improvements that concern AlwaysOn, I would like to focus on those described in the Microsoft KB3173156 and KB3112363. But in this first blog post, I will just cover those who concern…

Read More
Stéphane Haby

SQL Server 2016: New SQL PowerShell CMDLETs for ErrorLog

By | Database Administration & Monitoring | No Comments
 

 With the latest release of SQL Server Management Studio(SSMS) 2016 (13.0.15500.91), downloadable here, was introduced new CMDLETs for Always Encrypted, SQL Agent and the  ErrorLog. In this article, I will present you the 2 new CMDLETs for the Error Logs: Get-SqlErrorLog: Retrieves the SQL Server Logs. Set-SqlErrorLog: Sets or resets the maximum number of error log files before recycling. My first step is to search all commands with “Sql”: Get-Command | Select Name |Where-Object {$_.Name…

Read More
David Barbarin

SQL Server 2016 AlwaysOn: Direct seeding and backup considerations

By | Database Administration & Monitoring | No Comments
 

 As promised in my prior blog post, we’ll talk now about direct seeding feature and backups. We found an interesting LIMIT_CONCURRENT_BACKUPS value for current state of the hadr_automatic_seeding_state_transition event. As said last time, this value is meaningful by itself. So let’s try to perform a backup while the database is concerned by an active seeding session. In fact, my backup was blocked (as I supposed) and here what I found from the sys.dm_tran_locks and sys.dm_exec_requests…

Read More
Stéphane Haby

Set the SQL Native Client Default Port with PowerShell

By | Database Administration & Monitoring | No Comments
 

 I written an article about “SQL Server 2012: Configuring your TCP Port via PowerShell” and I received a question from PaulJ: “How do you set the port for the SQL Native Client 11.0 Configuration (32bit) – as seen in the SQL Configuration Manager?” This is a very good question and I decide to write this blog as an answer to this question. The first step is always the same, initialization of my object: [reflection.assembly]::LoadWithPartialName(“Microsoft.SqlServer.SqlWmiManagement”) |…

Read More
Mouhamadou Diaw

SharePlex Compare and Repair commands

By | Database Administration & Monitoring | No Comments
 

 Reading Franck Pachot blog about comparing source and target in a Dbvisit replication (http://blog.dbi-services.com/compare-source-and-target-in-a-dbvisit-replication/), I decide to write a small article about how we can do same thing with SharePlex. Indeed SharePlex provides built-in commands to compare and repair synchronization. Below is our configuration file. We are just replicating table article to article_rep. Both tables contain 2000000 rows datasource:o.SPLEXDB #source tables target tables routing map titi.article titi.article_rep atlasrep2@o.SPLEXSTR2 From the source let’s insert 2 rows…

Read More
Franck Pachot

Oracle Multitenant feature name

By | Database Administration & Monitoring | No Comments
 

 We all know what is the multitenant option: a container database (CDB) with multiple user pluggable databases (PDB). This requires Enterprise Edition plus option. But you can use the same architecture without the option and even in Standard Edition: a CDB with only one user PDB. It is called “single-tenant” or “lone PDB”. How do you call this new 12c architecture?

Read More