The Heap™ – Consultancy ©®

Evan Carroll

3:56 AM

dba.stackexchange.com/a/204487/2639 =)

hot2use

5:35 AM

Morning

Andriy M

Morning

hot2use

@PaulWhite silently rejoicing

McNets

6:49 AM

morning

Tom V

Morning

Andy K

7:16 AM

Morning and Evening

McNets

@JackDouglas nice!!! good job.

Andriy M

7:38 AM

Does the Audit Logout event happen only when the connection is deliberately closed by the client? Or is it triggered regardless of the nature of the disconnect (like timeout, for instance)?

I guess it could be easy to check but I don't know how to work with events to begin with, I need to know the answer in order to decide whether I should start learning how to use them

Tom V

8:16 AM

@AndriyM Audit logout is a profiler event, do you mean that or the XE logout?

Andriy M

@TomV See, I don't even know how they are called properly. Yes, I probably do mean that.

ConcernedOfTunbridgeWells

9:03 AM

Morning all

ypercubeᵀᴹ

Why was this edit approved? dba.stackexchange.com/review/suggested-edits/111255

hot2use

@ypercubeᵀᴹ Don't know.

Jack Douglas

@PaulWhite it is the most popular database in the world

and it now has window functions and CTEs!

hot2use

It wasn't me

Tom V

@ypercubeᵀᴹ I don't know why it was approved, but from a quick google I don't think that's how you concatenate strings in HiveQL either

hot2use

9:14 AM

Can we (or a moderator) rollback the Review?

ypercubeᵀᴹ

@TomV cwiki.apache.org/confluence/display/Hive/…

> Operator Types Description
> A || B strings Concatenates the operands - shorthand for concat(A,B) . Supported as of Hive 2.2.0.

@hot2use I rolled back the change. The review, I don't think anyone can.

Jack Douglas

Not mods anyway

Andriy M

Mods or OP should be able to revert an accepted edit, unless there's already a subsequent edit afer the suggested one.

I recently reverted an edit on an answer of mine

Jack Douglas

yes the edit can be rolled back, but not the review — it's still there in the history

Paul White

9:30 AM

@JackDouglas Must be the quickest adoption rate for a new release ever! ;)

Jack Douglas

there were so many things you could have taken issue with in my statement, but you chose that :p

everyone knows Oracle is the most popular db-engines.com/en

ho ho

ypercubeᵀᴹ

@JackDouglas does Oracle have DESC tablename command?

Jack Douglas

SQL*Plus does

and it works in SQLDeveloper, but it isn't actually an Oracle command

so it won't work in db<>fiddle: dbfiddle.uk/…

Andriy M

@JackDouglas I mean I reverted that edit after it was approved, and the editor lost the awarded 2 rep as a result.

The rollback was generated by the reversal: stackoverflow.com/posts/8694274/revisions

Jack Douglas

oh that's clever

Paul White

9:37 AM

@JackDouglas I'm trying not to be so predictable

Jack Douglas

like MySQL

Paul White

right :)

Andriy M

A mod can do that too, it just needs to be done before other edits are made to the post. In this case ypercube rolled back the edit explicitly, so the suggestion can be reverted.

Paul White

Correct except can -> can't

Jack Douglas

@AndriyM didn't know that

thanks

ypercubeᵀᴹ

9:39 AM

@JackDouglas Thnx. I wanted it for a question. Suspected that it was a MySQL user.

Andriy M

Looking for the Meta post where this was introduced...

Philᵀᴹ

@ypercubeᵀᴹ You could use dbms_metadata.get_ddl though

ypercubeᵀᴹ

Nice. Reputation list shows: +2 edit, then -2 reverted

Paul White

130

A: Could authors overturn recent community review decisions?

This has bugged me for years too; I have full edit rights over my own posts, I can single-handedly approve or reject any edit suggested to them if I catch it in time, why can't I override an approval or rejection if an edit happens to get reviewed while I'm asleep? Well, now we can! Oded toiled...

linked from the suggested edit faq meta.stackexchange.com/questions/76251/… @AndriyM

Andriy M

Wow... is it Friday yet?

Paul White

9:43 AM

> ...if the edit was previously approved, it will be marked Rejected and the previously-applied edit will be rolled back (complete with a comment in the revision history that describes what happened). If the editor earned +2 reputation for the edit, that will be retracted.

Andriy M

Thanks Paul

Paul White

@AndriyM mate it's practically Saturday

Andriy M

@PaulWhite I thought I was slow. Didn't realise I was that slow

2

hot2use

cool

ConcernedOfTunbridgeWells

10:00 AM

According to that:
Teradata is more popular than Sybase
Informix is more popular than SQL Azure
Netezza is more popular than Redshift

The lowest rank of anything I've ever heard of is LucidDB at 220

The lowest rank of anything I've ever actually installed on a computer is Gemstone/S at 166.

The lowest rank of anything I've ever met one of the developers of is Jade at 184.

The lowest rank of anything I've ever worked with in production is DataEase at 134

Andriy M

Mine are FoxBase and FoxPro, they aren't even listed

ConcernedOfTunbridgeWells

I wonder if they're still supported. I think MS punted support for Foxpro with VS7.

I did once apply for a job with a company that made a MUMPS-alike called AMPS. That probably counts as fairly obscure.

A friend of mine worked for another company that made another MUMPS-alike called GEM (short for Greatly Enhanced MUMPS).

MUMPS was quite historically significant in its way. It was the first 4GL with an integrated database platform, and it could run multiuser apps on remarkably low-spec machines.

The vendor of AMPS had an instance running a policy administration for an insurance company. It was running on an entry level HPUX server and took up about 512K of RAM (although the machine had a few MB of RAM on it).

Apparently some of the MUMPS variants could get a working system up in 64k or so.

Pick was another system that could bring multiuser applications up on really low spec machines.

gbn

10:21 AM

never worked on MUMPs but we had an install, about 15-16 years ago. some contractor came in at great expense to do his magic every month or 3. IIRC it ran on VAX/VMS

ConcernedOfTunbridgeWells

@gbn MUMPS and its clones ran on all sorts of machines. PDP-11s were a common host back in the cretaceous period.

MUMPS

MUMPS (Massachusetts General Hospital Utility Multi-Programming System), or M, is a general-purpose computer programming language that provides ACID (Atomic, Consistent, Isolated, and Durable) transaction processing. Its differentiating feature is its "built-in" database, enabling high-level access to disk storage using simple symbolic program variables and subscripted arrays, similar to the variables used by most languages to access main memory. The M database is a key-value database engine optimized for high-throughput transaction processing. As such it is in the class of "schema-less", "schema...

There we go. Integrated NoSQL database in 1966.

2

According to the article it started life on DEC hardware.

gbn

10:36 AM

@ConcernedOfTunbridgeWells Older than SQL then. Even older than us @ConcernedOfTunbridgeWells

ConcernedOfTunbridgeWells

@gbn Indeed. Half a century before its time.

jadarnel27

@ConcernedOfTunbridgeWells And RavenDB 4.0 thinks we should be impressed that it can run on a Raspberry Pi =P

ConcernedOfTunbridgeWells

@jadarnel27 I've seen GEM (a MUMPS-alike built by an alumnus from the original MUMPS team) running on PDP-11 in 64k.

That makes me feel old. I am, however still younger than MUMPS.

jadarnel27

@ConcernedOfTunbridgeWells Haha wow, that's nuts.

I wonder what kind of device you could even get these days that has 64k of RAM.

ConcernedOfTunbridgeWells

@jadarnel27 Mainly SOCs these days. There's probably a bit of aerospace kit of lower spec still flying with vendor support.

@gbn Wasn't your CORAL-66 application running on something with a disturbingly small amount of RAM?

gbn

10:42 AM

@ConcernedOfTunbridgeWells 192k of which 128k for code+data, upper 64k for data only

ConcernedOfTunbridgeWells

By all accounts there are still folks shipping 6502 cores on SOCs - the 6502 only takes about 3,500 gates so it has a really small silicon footprint in a SOC.

gbn

I can't remember the other system (VAX/VMS hosted with a FIXPAC cross-compiler) but it was assembler and i think has 64k

ConcernedOfTunbridgeWells

@gbn Running in an emulator on a VAX?

gbn

@ConcernedOfTunbridgeWells developed on VAX/VMS in FIXPAC assembler, cross-compiled for the radar kit itself which as some Ferranti chip discovery.nationalarchives.gov.uk/details/r/…

jadarnel27

I've had to Google almost every one of these acronyms.

gbn

10:46 AM

tsk tsk kids today

ConcernedOfTunbridgeWells

Uphill both ways etc.

Now get off my lawn.

jadarnel27

I got "SQL" without cheating =P

Tom V

@ConcernedOfTunbridgeWells We still have a customer with their LOB software written in Caché

ConcernedOfTunbridgeWells

@TomV I think there's still a fair amount of MUMPS or derivative code still in production.

gbn

The Ferranti chip. One of these bad boys https://www.museumwaalsdorp.nl/computer/en/ferranti.html

Edit: https://www.flightglobal.com/FlightPDFArchive/1973/1973%20-%202894.PDF "Ferranti computer for Nimrod's new radar"

Tom V

10:47 AM

@ConcernedOfTunbridgeWells It does seem to work well from what I have seen so why not

ConcernedOfTunbridgeWells

@TomV There is an argument to be made for 'if it ain't broke don't fix it.'

ypercubeᵀᴹ

@jadarnel27 Postgres runs on Raspberry Pi

ConcernedOfTunbridgeWells

@ypercubeᵀᴹ I've certainly run Oracle on machines of lower spec than a raspberry pi.

Tom V

@ConcernedOfTunbridgeWells I think they will keep using the system for as long as they can find developers

gbn

Just to add, in 1973 I was 4 years old. I starting working on it end of '91.

ConcernedOfTunbridgeWells

10:50 AM

@TomV Probably does the job and cheaper to keep running than replace it.

@gbn Developed in Bracknell. I wonder if that was before or after they put the maze of roundabouts in.

ypercubeᵀᴹ

@ConcernedOfTunbridgeWells !!

ConcernedOfTunbridgeWells

@ypercubeᵀᴹ Oracle 8.0 would run fine in about 64MB.

jadarnel27

@ypercubeᵀᴹ I did not know that, thanks! I have no experience with that product.

ypercubeᵀᴹ

We are actually thinking of using R Pis in production, for one of our customers.

gbn

@ypercubeᵀᴹ my first SQL Server (c. 1998, v6.5) had DEC Alpha chip(s?) and 64MB or 128MB.

ConcernedOfTunbridgeWells

10:55 AM

@ypercubeᵀᴹ Informix SE was developed on a VAX-11/750 (it was a part of the original Athena project) and would run quite acceptably in 4MB of RAM with a fairly substantial user base.

It did use a connect/fork model with a shared memory buffer pool so it used memory on a per-connection basis (early versions of INGRES and PostgreSQL did this) so it wouldn't necessarily scale to large numbers of punters on kit like that.

10 years earlier, IMS fastpath got a TPC-A benchmark of 100TPS on a 370/167 with 2x2.5 MIPS CPUs and 4MB of RAM.

IMS fastpath got its throughput by posting transactions asynchronously into a message queue. Imagine that. Eventual consistency in 1976.

ypercubeᵀᴹ

12:10 PM

Only 1 person liked my comment

@J... I like the cold shower approach. Literally. A bucket of cold water / ice should be enough. On the question "Why did you do that?" the answer would be of course "Why, I have no problem with it." — ypercubeᵀᴹ 16 hours ago

(well, at least it wasn't deleted!)

Paul White

12:32 PM

@ypercubeᵀᴹ Do not hold your breath

ypercubeᵀᴹ

@PaulWhite I'm sure it would get like +100 votes if it was posted as an answer among the first.

Or -100.

Paul White

Probably. Who knows on workplace :)

ypercubeᵀᴹ

You never know where the balance will go

Paul White

Some sites really do stretch the Q & A model to breaking point

hot2use

humming

Max Vernon

12:39 PM

AdBlock Plus just showed this in their latest update:

> The Open Source Rebel Alliance created new blocking filters that let you blast hidden ads on websites like Facebook, even if the Empire strikes back.

love it.

of course, I only ever use Facebook in a "private window", so they can bite me already.

Paul White

I stopped using Facebook when I realised I hated it

2

Max Vernon

lol. I hear that. I disabled the app on my phone so it cannot ever run.

Since then, I feel so much happier overall.

I'm no longer missing out on all the "fun" things my friends are doing tomorrow.

In the past, I've actually thoroughly deleted my Facebook account (not deactivated, actually deleted)... problem is my mum is on there and I'm the one who got her to use it as a way to keep up with us.

Now she's sharing anti-vaxxer memes and all kinds of terrible crap. I've created a monster.

3

ypercubeᵀᴹ

@MaxVernon That sounds like a selling title for a blog post

Max Vernon

@ypercubeᵀᴹ agreed, its got a good "hook".

ypercubeᵀᴹ

Help Me. My Mum is a Troll.

Max Vernon

12:47 PM

LOL

gbn

You can unfollow but stay connected as one option.

Had to do that for my mum

Max Vernon

I'm much more passive aggressive than that. I no longer check facebook at all, but at least I still follow her.

:-)

Paul White

having family/friends/acquaintances in the same space is a recipe for weirdness

hot2use

1:07 PM

@PaulWhite It is good for keeping up with relatives around the world. But in general it has become a sort of PITA.

Paul White

yes it has some uses, though it is not the only way to share picture/video/text

ypercubeᵀᴹ

@PaulWhite +10 to that.

Paul White

there's a reason I haven't invited my mum, wife, and friends to the heap

5

ypercubeᵀᴹ

I mainly used it for keeping in contact with acquaintances from the web or various (off and online) game activities. Then at some point, I accepted requests from some relatives and friends. It became a mess.

Paul White

as all things tend to do without active management

and clear features to enable that management

also it runs on MySQL so

ConcernedOfTunbridgeWells

1:11 PM

@PaulWhite But MongoDB is web scale.

Paul White

argh

ypercubeᵀᴹ

@PaulWhite that's a myth though. Some of the services run on mysql.

Paul White

@ypercubeᵀᴹ yeah I know, but it suits my current point

Noticed yesterday that Chrome uses SQLite

Which is actually ok by me

dezso

@MaxVernon which, in my case, popped up in an unsolicited new tab while reading The Heap. Now I have to find an AdBlocker² that blocks adblock from blocking me from The Heap.

@ypercubeᵀᴹ I keep it only for contacting the Hungarian dance community here and in Germany/Europe in general

no other friend requests are accepted

and strictly incognito mode

@PaulWhite FF too. It's fun to manage history through SQL (even if the browser cannot run during this).

now that we are at that, Google is famous for smart algorithms. At the same time, one of the worst ever is how search in history in Chrome/Chromium (not) works.

Max Vernon

2:18 PM

Is this answer too short? Should I expound upon the details, or is it suffice to say "don't worry, be happy"?

@PaulWhite - can your comment converter make Aaron's comment into an answer?

ahhh, I guess I can just do it with Community Wiki.

ypercubeᵀᴹ

2:49 PM

FoundationDB is open source

Andy K

3:02 PM

cya guys

ypercubeᵀᴹ

Forrest

@ypercubeᵀᴹ I see sum problems with that...

McNets

3:21 PM

SELECT SUM(ESTABLISHED + ELEVATION + POPULATION) AS DUMMY_TOTAL
FROM SNOWMASS_VILLAGE

Max Vernon

that's called targeting the desired answer

There are lies, damn lies, and statistics.

that clearly falls in the latter category, since they can hardly be called liars.

Paul White

@MaxVernon yes thanks

Max Vernon

@PaulWhite now, if only I could delete comments.

Paul White

@MaxVernon you already did

Max Vernon

@PaulWhite it takes 2 or 3 flags for them to be deleted without mod intervention?

or am I misunderstanding

Paul White

3:27 PM

@MaxVernon I mean you caused their deletion

Max Vernon

ahhh, cool

are you getting sick and tired of being a monkey with a gun yet?

;-)

Is there any way to determine how much space DBCC CHECKDB will require in tempdb for a sort?

I guess I should ask on main

Paul White

@MaxVernon Not at all! I am happy to do it. It's hardly ever exciting or cool, but it is necessary.

@MaxVernon estimate only or sthg like that

Max Vernon

@PaulWhite hmmm... look at that! thanks

Paul White

> ESTIMATEONLY

Displays the estimated amount of tempdb space that is required to run DBCC CHECKDB with all the other specified options. The actual database check is not performed.

ypercubeᵀᴹ

148

Q: How do comments work?

Across the Stack Exchange network you may leave comments on a question or answer. How do comments work? Who can post comments? Who can edit comments? How can I format and link in comments? Who can delete comments? When should comments be deleted? What are automatic comments? How can I link to c...

Max Vernon

3:31 PM

@ypercubeᵀᴹ thanks

ypercubeᵀᴹ

> Comments that are flagged by multiple users are deleted automatically. The number of flags needed is based on the comment's score. It currently takes "3 + (Score / 3)" flags to delete a comment. Comments containing certain keywords can reduce this amount.

Paul White

I think it would be nice if flagged comments were hidden for the flagger until those flags were processed.

(so they act as if deleted)

If the system were really smart it would auto-delete comments with content copied into a recent answer.

Max Vernon

@PaulWhite that would be really helpful, yes.

and quite frankly, the 5 second delay between delete requests seems a bit dumb.

Paul White

everything has to be rate limited due to people being people

and sadly rep is not a reliable guide to responsibility

but yeah ikwym

Max Vernon

I've been slowly making my way through sql-server-2008-r2 unanswered questions. Man, there are a lot of unanswered questions on the site.

Paul White

3:41 PM

7,758 total out of 64,970

that seems about right

Max Vernon

And many questions are just plain incredibly hard to answer. I'm a bit reluctant to VtC as "off topic - Too Localized" since, who knows, at some point in say, 2040 someone may answer them.

@PaulWhite I wonder if the trend for that is going in the right direction or not. And clearly, I'm too lazy to look at the data explorer ;-)

Paul White

@MaxVernon you can get those numbers from the home page

also a summary is available at stackexchange.com/sites#technology-percentanswered

Max Vernon

@PaulWhite I was referring to the trend (i.e. is the percent of answered questions rising over time or decreasing over time).

Paul White

@MaxVernon From memory it has always been around that level. Not all unanswerable/poor questions get closed/deleted.

Max Vernon

this question is a good example of a potential VtC "too localized"... I tried to repro the problem but had no luck. As of now, I'm just abandoning looking at it.

I suppose I could VtC it and let the community decide.

I guess I'm reluctant to VtC as "too localized" since it has the Paul White One Up Vote™ which says it's helpful to me. ;-)

(just guessing it's you upvoting those)

Paul White

3:50 PM

@MaxVernon I have not voted on that question

Max Vernon

@PaulWhite I wonder how many people create an extra account just to upvote their own question in hopes of getting it answered faster.

Paul White

@MaxVernon Not many I hope since that would be abuse. Also, voting up is a privilege that must be earned.

Max Vernon

@PaulWhite oh right, I forgot about that privilege thingy.

Paul White

> The system will automatically delete unlocked, unanswered questions on main (non-meta) sites with score of zero (or one, if the owner is deleted), fewer than 1.5 views per day on average, and fewer than two comments that are at least 365 days old. (RemoveAbandonedQuestions)

So I think the up vote is the only thing keeping that question alive

Max Vernon

@PaulWhite so downvotes negate that single upvote... ahhh clearly yes, "score" not "upvoted". Imma go on a downvote spree.

but only for those that deserve it.

Paul White

3:55 PM

Voting is a very effective tool :)

Max Vernon

@PaulWhite I love that question votes are free.

Paul White

e.g. in this case, down vote = auto delete by system. Vote to close would lead to a review involving at least five people, and possible closure, but no system deletion while the score stays positive.

Max Vernon

strangely, I still feel bad when I click the button.

Paul White

meh think of it as giving anonymous feedback on the quality of the question (not the poster)

Max Vernon

@PaulWhite that's the problem I have, I think of the poor asker.

I remember how disheartening it was to get a downvote at the beginning on Stack Overflow

Paul White

3:58 PM

understood. but if one only ever gets positive feedback, how is one to know they could improve?

Max Vernon

to me, it's incredible anybody stays on Stack Overflow past the first question that gets downvoted 6 times in 8 seconds.

@PaulWhite good point

Paul White

well yeah that is unhelpful

otoh it doesn't affect rep much

Max Vernon

true

Paul White

or at all, if the post ends up being deleted, or if the OP has only 1 rep to begin with

Max Vernon

ahhh yes, that is also a good point to keep in mind.

@PaulWhite presumably those auto-deletes happen once-per-day, I guess.

Paul White

4:01 PM

@MaxVernon yep, job

the system is quite conservative about deletion

if we had a review queue for delete votes I expect we would manually delete many more

Boosting the answered percentage

ypercubeᵀᴹ

@Sean is gone, @JoeObbish is gone, the Heap feels a bit inactive these days

Max Vernon

@PaulWhite holy crap, this db thinks it needs 912GB of tempdb???

> Estimated TEMPDB space (in KB) needed for CHECKDB on database shrpnt_cntnt_colbrtn_005 = 912735212.

the database is less than 100GB

Paul White

I guess that's estimates for you

Max Vernon

:44129628 that's what it claims in the message

Paul White

The (in KB) would suggest so

No hiding behind a (removed)

ypercubeᵀᴹ

4:08 PM

What (removed)?

Paul White

ha ha ha

@ypercubeᵀᴹ That one :)

ypercubeᵀᴹ

haha

Paul White

@ypercubeᵀᴹ Well Joe wrote a lot of messages, but they were largely on a specific topic that now has its own room. Overall activity is about the same as ever. It waxes and wanes over time.

Evan Carroll

@MaxVernon I VTC because I think you're probably right, but I did find this dba.stackexchange.com/a/204544/2639

Max Vernon

@EvanCarroll nice one. weird, but cool!

it seems like that's related to an upgrade to SQL Server 2000 though, no?

Paul White

4:18 PM

I am so glad I explained at length how auto-deletion works

Evan Carroll

No, it seems like generic problem with architecture/protocol mismatches between 64-bit clients and 32-bit servers.

Max Vernon

@PaulWhite me too. Believe me, it was not wasted ;-)

@EvanCarroll there are no protocol differences between 32 and 64 bit for SQL Server

Evan Carroll

My guess it that some kind of result set SQL Server is sending to the client is also transmitting a pointer to a server, or maybe a cursor and that's the wrong size and that cryptic mess is how SQL handles it.

ypercubeᵀᴹ

Max's mission achieved, one less unanswered question.

Evan Carroll

@MaxVernon obviously there must be some kind of difference in that bug, it's whatever sp_addlinkedserver does assumes it's connected to a 32-bit client.

That assumption is invalid, so the resolution to that bug is to updated the stored procedures, but those procedures are making some kind of faulty assumption about what they're talking to.

Max Vernon

4:23 PM

@EvanCarroll no, the page states the cause of the problem is connecting to a down-level SQL Server 7.0 server from a SQL Server 2000 server.

they state that to fix it you can run a script against the SQL Server 7 instance to bring the schema metadata up to SQL Server 2000 compataibility

Evan Carroll

If they have a different protocol when the server acts as a client to another server, than from when a user's TSQL client connects -- sure.

Max Vernon

@EvanCarroll its the same protocol.

msdn.microsoft.com/en-us/library/dd304523.aspx

Evan Carroll

That would be my assumption too, which gets back to there being some kind of assumption that's wrong.

From the 32-bit/64-bit mismatch

Max Vernon

TDS, or Tabular Data Stream

jadarnel27

Max Vernon

4:29 PM

@EvanCarroll even more fun, with SQL Server you can restore a database from a 64 bit instance onto a 32 bit instance without any issue whatsoever. Try that with PostgreSQL.

why anyone would ever do that is, of course, another matter entirely.

ypercubeᵀᴹ

@MaxVernon Of you can restore it, why couldn't you?

From a Linux backup, you can restore in Windows or the opposite.

Max Vernon

@ypercubeᵀᴹ apparently the page format is different between various flavors. Unless I'm remembering incorrectly. Might be wrong.

ypercubeᵀᴹ

@MaxVernon The page format is different. That affects a pg_basebackup (a whole instance backup). If you mean that, yes, you can't restore it in a different OS/architecture

Max Vernon

@ypercubeᵀᴹ as you can tell, I'm not a PostgreSQL expert ;-)

also, there is an outside chance I was just being snarky.

jadarnel27

"outside chance" - pffft

ypercubeᵀᴹ

4:39 PM

Didn't notice ;)

jadarnel27

=P

Evan Carroll

5:51 PM

@MaxVernon you can do that easily with PostgreSQL using pg_dump and pg_restore =)

MikeTheLiar

7:56 PM

Disclaimer, I only have access to diagnostic information about this problem, I don't know much about the actual queries that are running. MS SQL Server 2012. Our Solarwinds monitoring software is flagging one particular stored procedure as 1) being starved for memory/CPU resources, as well as blocking other queries. However the database host reports that CPU/memory are barely being touched.

Which is weird to me because to the best of my knowledge SQL Server will lay claim to as much ram as you'll give it, regardless of whether it's needed or not. Memory and processor configuration for the SQL instance look correct.

Max Vernon

@MikeTheLiar what does max server memory and min server memory in sys.configurations show?

MikeTheLiar

Oh that's terrible, one sec

+---------------------------+------------+---------+------------+
|             name          |   value    | minimum |  maximum   |
+---------------------------+------------+---------+------------+
|    min server memory (MB) |          0 |       0 | 2147483647 |
|    max server memory (MB) | 2147483647 |     128 | 2147483647 |
+---------------------------+------------+---------+------------+

brb

jadarnel27

8:14 PM

Your server has two petabytes of RAM?! =P

Max Vernon

ahhh, yes. looks like you might want to adjust those a bit. dba.stackexchange.com/questions/84234/…

MikeTheLiar

Reading

Max Vernon

really great "why is my query slow today" question and answer, @sp_BlitzErik

4

Q: Why is my query suddenly slower than it was yesterday?

[Salutations] (check one) [ ] Well trained professional, [ ] Casual reader, [ ] Hapless wanderer, I have a (check all that apply) [ ] query [ ] stored procedure [ ] database thing maybe that was running fine (if applicable) [ ] yesterday [ ] in recent memory [ ] at some point I've a...

sql-server query-performance execution-plan parameter-sniffing

that should go on the list of canonical resources that we should make in Database Administrators Meta

oooooh we have one... who knew! dba.meta.stackexchange.com/questions/708/canonical-answers

2

MikeTheLiar

People wearing CrossFit shirts who aren't injured: Zero dear god, that man had a family!

jadarnel27

@MikeTheLiar Are there are other workloads (other than SQL Server) running on that server (SSAS, SSRS, IIS, a minecraft server, command prompt forkbombs, etc)?

MikeTheLiar

8:28 PM

I mean, just the BTC miners I set up while IT wasn't looking but other than that, no.

Max Vernon

@jadarnel27 I like to run bitcoin mining on my SQL Servers.

@MikeTheLiar lol, great minds

MikeTheLiar

bows

jadarnel27

I'd be surprised if that setting is causing your problem, unless there's something else periodically / constantly telling SQL Server to give up the RAM it has. Although adjusting that setting is still sound advice.

Well played you two haha. I can't believe I left bitcoin out of the list.