@AndriyM @hot2use @dezso Just an update: a community manager has now merged the users on dba.stackexchange.com/q/213848

@MDCCL Please answer on:

and anyone else of course

@PaulWhite Thanks for the info.

Good morning and evening

Morning

@PaulWhite Thanks

@hot2use No worries. Please add a suggestion to the new meta design question as well?

Now the problem is to figure out whether that's really a DB design question and not a mixture of DB design + app design

What does Master Database do all day?

@PaulWhite Dunno. Enlighten us...

sleeps all day? :)

Seems like

@PaulWhite Yeah, I might give it a go.

Quick question for The Heap™ – Consultancy ©®:

> What "perfmon counters / extended events / dm_exec_* tables" should I use if I want to locate IO issues when querying Binary/Text fields in a database on SQL Server 2016 which was previously performing better on a SQL Server 2014 instance? The servers are pretty much the same. Virtual server with 65 GB RAM. Old: 12 GB assigned (multi-database instance) / New: 8 GB assigned (dedicated instance)

Yes, I know it might be worthy of a Q (& A), but I'm in a hurry

I've so far got Paul Randall's script rigged up to trace 1 hour of sys.dm_os_wait_stats for starters.

Morning

Morning

ASYNC_NETWORK_IO says it all.

Morning all

So, in other news today, the production staff have finally twigged onto the notion that 'read access to production' is not a terribly good solution for data profiling work. One of them even helpfully suggested an environment that they could restore a copy of production into.

Seen on the interwebs today ...

git-man-page-generator.lokaltog.net

@ConcernedOfTunbridgeWells that's actually easier to read understand than the real git instructions.

@hot2use apparently no good questions have a quick answer. Have you tried configuring the new instance with 12GB, just to see if that nugget is the answer?

In related news, there are over 100,000 questions tagged git on Stackoverflow. stackoverflow.com/questions/tagged/git

So tags work on profile blurbs as well.

@hot2use have you checked sys.dm_io_virtual_file_stats to see if there is legit I/O latency, or just more I/O than before?

Though it sounds like maybe you found it with all the ASYNC_NETWORK_IO.

@MaxVernon Been analysing a bit and it looks like it's an issue with Citrix and a local directory being mapped to a network share, which Citrix is trying to access, which results in a round-trip until the file is displayed in the Citrix session.

DB -> Appl Srv -> Citrix Client -> User Computer -> User Share -> User Computer -> Citrix Session -> User Computer

- - - - - - - - - - - - - - - - - - - - - FILE  - - - - - - - - - - - - - - - - - - - - - - - - - >

This is interesting stackoverflow.com/questions/52427018/…

It's possible there's something funky about the collation. Given that Khmer is largely spoken in some fairly poor third-world countries it's possible that it didn't get a lot of attention from Microsoft's testing staff.

@gbn reminds me of this

and we got bit by a collation bug yesterday which is why I have that link handy

@gbn speaking of which, how's life in a small, third-world country?

@Taryn Thanks, added a comment with link

@ConcernedOfTunbridgeWells Fair to middling. How's blighty?

Bugger me. I actually had some inkling that there was a small minority in Vietnam who spoke Khmer and verily - The Khmer language now serves as the official language of Cambodia, where it is spoken by the majority of the population, an estimated 14,494,293 people. It is also spoken by approximately 1.3 million people in southeast Thailand and by more than 1 million people in southern Vietnam.

@gbn Not bad. I have a peculiarly British problem in that I've just gone contracting and the outfit doing tenancy references is bouncing me because I haven't got 6 months history in it.

Only around London could you earn a contract rate and have trouble renting a house. #FirstWorldProblems.

@ConcernedOfTunbridgeWells I'm not surprised...

Solomon's knowledge of unicode, collations, and other arcane bullshit regularly blows my mind.

@PaulWhite I like your suggestion, and Jacks' as well. Working on mine right now.

@gbn In related news, the prospective landlord's rental insurance will have their landord's indemnity requirements covered if I can come up with 12 months' rent in advance.

Funnily enough, about this time next month I could actually do that.

I am not amused.

@ConcernedOfTunbridgeWells Even the conservative Swiss aren't so anal

I suspect this one is going to fall through.

How goes it folks

@ConcernedOfTunbridgeWells Ooo I like that a lot.

They might need to reduce the height but hopefully not too much. At 80% the details are still discernible enough to make sense

Looks really nice

@AndriyM I'm sure they can produce specs with exact dimensions and suchlike. If necessary I've got Adobe CS6, visio etc. and could knock up a model that's not actually based on somone's production system.

Getting it to tesselate might be a challenge.

this is not offensive, is it?

@MaxVernon seems all the parties agreed in the end

hopefully!

except for where I've fixed it, the existing nightly maintenance jobs we run do ALTER INDEX REBUILD / REORG followed by UPDATE STATISTICS ... every night, in that order, without regard to the fact the ALTER INDEX REBUILD performs UPDATE STATISTICS for any stats object used by that index. What a waste of time. I've fixed it on many instances by not updating any stats object that has been updated in the past 12 hours (by default, as a parameter to a proc).

well, that's an interesting plane

and I thought the Concordes where all but gone.

This is the G-BOAB Concorde at Heathrow

earning your stripes on every stackexchange is no fun.

inline tag edits are bread and butter shit

@Zane hey! pretty well here, how's things?

@ConcernedOfTunbridgeWells you should put that information in your meta answer