Diane @sql2go

DBA by trade... No really, wanna trade? Unfortunately, I've only achieved 66.66% uptime, my system continually crashes between 12-6 am. Maybe I need a patch! Vancouver, BC Joined October 2011

Tweets

450
Followers

105
Following

99
Likes

46

Diane @sql2go

10 months ago

Hey friends! Want to work somewhere exciting and fun? Great colleagues and perks? Make a difference in helping people find love and connection? Then check this out & apply or let me know if you want more info #sql #BigData #aws #sqlserver #databricks join.matchgroupcareers.com/careers/job/30…

0 0 0 10 0

View Details

Diane @sql2go

2 years ago

@sd43bc Is it actually closed? Where is this being reported. Website is so busy it’s still crashing!

0 0 1 495 0

View Details

Diane @sql2go

5 years ago

@SQLSocialite FYI I solved it myself. The standby.signal file wasn't in the expected location, and I had to use "SHOW data_directory;" to find the correct one and remove the trigger file there.

0 0 1 0 0

View Details

Diane @sql2go

5 years ago

FYI I solved it myself. The standby.signal file wasn't in the expected location, and I had to use "SHOW data_directory;" to find the correct one and remove the trigger file there.

0 0 0 0 0

View Details

Diane @sql2go

5 years ago

I actually updated the question as it's the reverse where the standby is trying to connect to the primary, not the other way around. However I've already ensured the primary_conninfo is removed as well as the trigger file, so it's still an issue.

1 0 1 0 0

View Details

Diane @sql2go

5 years ago

If anyone understands why this is happening I'm all ears! dba.stackexchange.com/q/300272/94927… #PostgreSQL @pgexperts

1 0 1 0 0

View Details

Diane @sql2go

5 years ago

@SQLSocialite Thanks Scott! I actually updated the question as it's the reverse where the standby is trying to connect to the primary, not the other way around. However I've already ensured the primary_conninfo is removed as well as the trigger file, so it's still an issue.

1 0 1 0 0

View Details

Diane @sql2go

5 years ago

If anyone is interested please let me know! linkedin.com/posts/activity…

0 0 0 0 0

View Details

Diane @sql2go

6 years ago

@PaulRandal @ReidDeWolfe Here's the Client Statistics from the other test server, which shows query profile and network statistics to be the same, but with vastly different Client processing times.

0 0 0 0 0

View Details

Diane @sql2go

6 years ago

@PaulRandal @ReidDeWolfe As well, I'm only testing this script against SSMS. It's actually generated and run by Redgate DLM tool, so I imagine it's using SQLCMD already and encountering the same issue.

1 0 0 0 0

View Details

Diane @sql2go

6 years ago

Why does a 3000 line row-by-row INSERT script perform better with a GO after each statement than without? Script is only 481KB and takes a few seconds with GO and a few minutes without. It can’t all be parse/compile? #sqlhelp

5 0 2 0 1

View Details

Diane @sql2go

6 years ago

@PaulRandal @ReidDeWolfe Same issue.

0 0 0 0 0

View Details

Diane @sql2go

6 years ago

@PaulRandal @ReidDeWolfe This script is an example of what gets created using Redgate's DLM tool to deploy changes. For now, we're using the option to split transactions/batch operations to reduce the time it takes. Couldn't find much documentation on what Client Processing Time issues could be.

0 0 0 0 0

View Details

Diane @sql2go

6 years ago

@PaulRandal @ReidDeWolfe It should be noted I've already checked for log/data growth, and we've taken a look for errors in the SAN storage and networking layer, but haven't come up with anything. Memory and CPU are under-utilized, and MAXDOP settings are set to 0. No errors or of IO latency in logs.

1 0 0 0 0

View Details

Diane @sql2go

6 years ago

@stridergdm I compared Client Stats with and without GO, and though packets and bytes sent/received were more with GO, Client Processing Time was nothing in comparison, though Wait Time on Server Replies increased slightly.