Click here to Skip to main content
14,490,488 members
   

Database

 
RantLatest Oracle Connection method Pin
Mycroft Holmes6-May-18 14:56
professionalMycroft Holmes6-May-18 14:56 
GeneralRe: Latest Oracle Connection method Pin
Jörgen Andersson16-May-18 0:20
professionalJörgen Andersson16-May-18 0:20 
GeneralRe: Latest Oracle Connection method Pin
Mycroft Holmes16-May-18 0:27
professionalMycroft Holmes16-May-18 0:27 
GeneralRe: Latest Oracle Connection method Pin
Jörgen Andersson16-May-18 0:37
professionalJörgen Andersson16-May-18 0:37 
QuestionSQL 2016 Optimization ... Pin
Member 138060854-May-18 1:10
MemberMember 138060854-May-18 1:10 
RantRe: SQL 2016 Optimization ... Pin
CHill604-May-18 1:13
mveCHill604-May-18 1:13 
AnswerRe: SQL 2016 Optimization ... Pin
Eddy Vluggen5-May-18 1:14
professionalEddy Vluggen5-May-18 1:14 
QuestionSQL 2016 Optimization ... Pin
Member 138060854-May-18 1:10
MemberMember 138060854-May-18 1: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 14:12
Memberindian1432-May-18 14: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 8:41
Memberindian1433-May-18 8:41 
QuestionInsert dynamic SQL Values into Temp Table Pin
indian14326-Apr-18 7:03
Memberindian14326-Apr-18 7:03 
AnswerRe: Insert dynamic SQL Values into Temp Table Pin
Richard Deeming26-Apr-18 8:00
mveRichard Deeming26-Apr-18 8:00 
GeneralRe: Insert dynamic SQL Values into Temp Table Pin
indian14326-Apr-18 10:09
Memberindian14326-Apr-18 10:09 
Questionmysql query Pin
Member 1360728325-Apr-18 16:47
MemberMember 1360728325-Apr-18 16:47 
AnswerRe: mysql query Pin
Jörgen Andersson25-Apr-18 21:48
professionalJörgen Andersson25-Apr-18 21:48 
GeneralRe: mysql query Pin
Member 1360728326-Apr-18 10:56
MemberMember 1360728326-Apr-18 10:56 
GeneralRe: mysql query Pin
Jörgen Andersson26-Apr-18 21:22
professionalJörgen Andersson26-Apr-18 21:22 
QuestionShipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 4:51
Memberbfg9000d36025-Apr-18 4:51 
AnswerRe: Shipping tracking Link output to google search from MYSQL Database Pin
Eddy Vluggen25-Apr-18 5:37
professionalEddy Vluggen25-Apr-18 5:37 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 7:19
Memberbfg9000d36025-Apr-18 7:19 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Eddy Vluggen25-Apr-18 8:19
professionalEddy Vluggen25-Apr-18 8:19 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 8:31
Memberbfg9000d36025-Apr-18 8:31 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Eddy Vluggen25-Apr-18 8:38
professionalEddy Vluggen25-Apr-18 8:38 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Richard Deeming25-Apr-18 9:46
mveRichard Deeming25-Apr-18 9:46 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 9:50
Memberbfg9000d36025-Apr-18 9: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.