Click here to Skip to main content
14,768,261 members
Home » Discussions » Database
   

Database

 
RantLatest Oracle Connection method Pin
Mycroft Holmes6-May-18 15:56
professionalMycroft Holmes6-May-18 15:56 
GeneralRe: Latest Oracle Connection method Pin
Jörgen Andersson16-May-18 1:20
professionalJörgen Andersson16-May-18 1:20 
GeneralRe: Latest Oracle Connection method Pin
Mycroft Holmes16-May-18 1:27
professionalMycroft Holmes16-May-18 1:27 
GeneralRe: Latest Oracle Connection method Pin
Jörgen Andersson16-May-18 1:37
professionalJörgen Andersson16-May-18 1:37 
QuestionSQL 2016 Optimization ... Pin
Member 138060854-May-18 2:10
MemberMember 138060854-May-18 2:10 
RantRe: SQL 2016 Optimization ... Pin
CHill604-May-18 2:13
mveCHill604-May-18 2:13 
AnswerRe: SQL 2016 Optimization ... Pin
Eddy Vluggen5-May-18 2:14
professionalEddy Vluggen5-May-18 2:14 
QuestionSQL 2016 Optimization ... Pin
Member 138060854-May-18 2:10
MemberMember 138060854-May-18 2:10 
Hello,

I have two SQL 2016 Always On nodes - (VMware Virtual Machines). Each node has 250GB RAM, 46 vCPU @2.5GHz. Each of the MS SQL VM is dedicated to 1 ESXi Host so there is no resource contention.

The application that would connect to the Database is expected to be: 70% WRITE and 30% READ.

I need advise on the best way to:

(1.) Configure MS SQL nodes to use the 250GB RAM, 46 vCPU efficiently and optimally.

(2.) Perform Write and Read as fast as possible using all the hardware resources.

(3.) I have configured Always On Read Routing, how can I test it?

Thanks.
QuestionHow to stop execution of other tasks in SSIS if a script task gets Dts.TaskResult = (int)ScriptResults.Failure; Pin
indian1432-May-18 15:12
Memberindian1432-May-18 15:12 
AnswerSelf answered just if somebody has similar problem it would be helpful. How to stop execution of other tasks in SSIS if a script task gets Dts.TaskResult = (int)ScriptResults.Failure; Pin
indian1433-May-18 9:41
Memberindian1433-May-18 9:41 
QuestionInsert dynamic SQL Values into Temp Table Pin
indian14326-Apr-18 8:03
Memberindian14326-Apr-18 8:03 
AnswerRe: Insert dynamic SQL Values into Temp Table Pin
Richard Deeming26-Apr-18 9:00
mveRichard Deeming26-Apr-18 9:00 
GeneralRe: Insert dynamic SQL Values into Temp Table Pin
indian14326-Apr-18 11:09
Memberindian14326-Apr-18 11:09 
Questionmysql query Pin
Member 1360728325-Apr-18 17:47
MemberMember 1360728325-Apr-18 17:47 
AnswerRe: mysql query Pin
Jörgen Andersson25-Apr-18 22:48
professionalJörgen Andersson25-Apr-18 22:48 
GeneralRe: mysql query Pin
Member 1360728326-Apr-18 11:56
MemberMember 1360728326-Apr-18 11:56 
GeneralRe: mysql query Pin
Jörgen Andersson26-Apr-18 22:22
professionalJörgen Andersson26-Apr-18 22:22 
QuestionShipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 5:51
Memberbfg9000d36025-Apr-18 5:51 
AnswerRe: Shipping tracking Link output to google search from MYSQL Database Pin
Eddy Vluggen25-Apr-18 6:37
professionalEddy Vluggen25-Apr-18 6:37 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 8:19
Memberbfg9000d36025-Apr-18 8:19 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Eddy Vluggen25-Apr-18 9:19
professionalEddy Vluggen25-Apr-18 9:19 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 9:31
Memberbfg9000d36025-Apr-18 9:31 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Eddy Vluggen25-Apr-18 9:38
professionalEddy Vluggen25-Apr-18 9:38 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Richard Deeming25-Apr-18 10:46
mveRichard Deeming25-Apr-18 10:46 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 10:50
Memberbfg9000d36025-Apr-18 10:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.