Aw man... accepted answer revoked cause I was too sassy in comments 😂 #feelsBadMan
Perhaps I should be a good netizen and invite the noob to chat, eh?
Ugh... perennial problem - is there a shortcut for “create chat for a question” that populated the title and invites the post owner? Or is that legit a manual process every time?
The help center suggests that after creating a chat room I should be able to invite users to chat from the room menu.
I created a room to discuss a problem but the room menu has no such invite function.
Other questions suggest I should only be able to invite users who are already in a chat.
Up...
@PeterVandivier So I looked at your partition-checktable.sql script and I think to recreate the issue you will need to create approx 160 column wide table.
I think that was the item I left off my issue and I have added it to the solution
@Russ960 I’ll re-run it with 160 cols per table, but my interpretation of your answer was that the tipping factor was the number of partitions - not so much the data size
Given what you got back from the support case that you may not have shared on your answer - are you able to modify my gist to either
1) reproduce the issue
2) create a trend as number of partitions / data volume increases?
The ##foo.csv on the gist shows the greatest increase in dbcc exec time appearing to correlate with creation of new partitions - once the number of partitions levels off, there is addition load, yea, but nowhere near 15 mins clock time
To be fair - is 400k partitions representative of what you had / cleared out?
I used 200x2000 from the answer for the retro but You also note that sysrscols had 200 MM rows? So... a few orders of magnitude diff
Also - fwiw - you’re not the “👋🏻“ I was referencing earlier 🤪
Your post was actually the topic of muchdiscussion hence why I brought it here
The error in the image is blindingly obvious, and the link in your question says quite clearly, with bits bolded: "You must make the MASTERS'S server_id 1 and the SLAVEACCOUNT'S server_id = 2". — Philᵀᴹ6 mins ago
If I need to chill a little and be a bit nicer, I'd like you all to tell me. I guess I'm getting a little grumpy with the question quality the last few days
@PeterVandivier So it cols were important to the solution I realized I left that off after your question which I appreciated. From the MS rep: "When a table is partitioned, the # of rows in the sysrscols table increase by the # of columns in the table that has been split by a partition."