Slow query in production, bad plan or stale index?

I’ve just fixed a production performance issue by dropping an index and recreate it. I suspect dropping the index also dropped executions plans that used it and one of them happen to be bad.

Arguments in favor of bad execution plan :

  • Before dropping the indexe, I looked up the last update date for the statistics on the given table and they were up to date.
  • My DBA has put in place Hallengren’s index and statistic maintenance solution
  • The slow query was a select statement executed from sp_executesql with dates parameters. Executing the same select statement without sp_executesql was fast, but also didn’t use the same execution plan.

Arguments against bad execution plan :

  • Before dropping the indexe, we went real wild and runned the forbidden dbcc freeproccache to clear any bad plan, but this didn’t fix or change the performance issue.

Note:

  • The slow query happen to be using a table indexed by date. However, there is wide differences in the amount of records for each date. In other word, any given date range from few records to more than 100k and it is pretty random.

  • The database is running under compatibility level 140 (SQL Server 2017)

Was the source of the problem a bad plan or a stale indexe?

MyW – 50GB Reseller Hosting Plan, with discount provided at checkout! Germany and Los Angeles locations!

MyW contacted us to tell us about their latest changes. What they had to say was that for them, due to the recent cPanel price hiking, they’ve decided to migrate to DirectAdmin. They informed us that the experience has been awesome and their clients are actually enjoying the UI, most of them even prefer it versus cPanel.
They have provided an offer specifically created for this community of a Reseller Hosting plan with a discount that’s provided at checkout!
If you decide to buy, we look forward to your feedback in the comments section below!

They accept PayPal and Credit Cards as payment methods. You can find their ToS/Legal Docs here.

Here’s what they had to say: 

“MyW is a new division for WNDP – WebNegócio Lda. (VAT PT513780542), a business registered in Portugal since December, 2015. Even though this is a new division, we have been selling WebHosting, locally, since 2004. Due to the cPanel price hikes, we felt it was just about time to expand to the international market. So far so good and our clients have been loving the new UI!”

Here’s the offer: 

50GB Reseller Hosting

  • 50GB SSD Storage
  • Unmetered Bandwidth
  • Shared IP Address
  • Unlimited Clients
  • DirectAdmin Access
  • Softaculous Script Installer
  • LiteSpeed Web Server
  • MailChannels
  • DDoS Protection
  • Falkenstein, Hetzner, Germany or Los Angeles, CA, USA
  • €4.30 a month / $ 4.86 a month
  • [ORDER]

NETWORK INFO:

Falkenstein, Germany, EU

Test IPv4: speed.hetzner.de
Test file: https://speed.hetzner.de/1GB.bin

Los Angeles, California, USA

Test IPv4: speed.hetzner.de
Test file: http://los-angeles-speedtest.reliablesite.net/1000mb.test.zip

Hardware Information:

– Intel Xeon E3 1246v3

– 32GB

– 4x 1TB SSD’s @ RAID 5

– 1Gbps Network

Please let us know if you have any questions/comments and enjoy!

The post MyW – 50GB Reseller Hosting Plan, with discount provided at checkout! Germany and Los Angeles locations! appeared first on Low End Box.

Whitelabel ITSolutions – Coupon Code for 3GB VPS Plan with Free Migration!

Whitelabel ITSolutions, sent in a new offer for the community, complete with a coupon code for a VPS Plan, that we felt was worthy to display to you!
With this coupon code listed below, used at checkout, you will be getting a discounted price on their 3GB VPS Plan, that also comes with Free Migration.

Their WHOIS is public, and you can find their ToS/Legal Docs here. They accept Credit Card and PayPal as payment methods.

Here’s what they had to say: 

“Established in 2015, Whitelabel ITSolutions is one of the most reliable collocation hosting providers in the United States. With our main data centers in New Jersey, Whitelabel ITSolutions is staffed with a certified team of engineers with a vision of delivering a fully integrated, trusted collocation hosting service. Whether you need a server, backup services or a place to host your full IT infrastructure, Whitelabel ITSolutions will be able to provide a plan for you all with an unparalleled 24/7 customer support available whenever and wherever our clients need it. ”

Here’s the offer: 

3GB VPS

  • 3G RAM
  • 2x vCPU
  • 40GB HDD space
  • 6TB transfer
  • 1Gbps uplink
  • 1x IPv4
  • /123 IPv6
  • OpenVZ/SolusVM
  • Coupon Code: LEBEXCLUSIVE
  • $ 7/month
  • [ORDER]

NETWORK/HARDWARE INFO:

Hackensack, New Jersey, USA

Test IPv4: 199.38.247.250

Test file: https://whitelabelitsolutions.com/data-center/network-tests/


Host Node Specifications:

– 4x Intel Xeon E74870 CPU

– 256GB RAM

– 6x 1TB HDDs SSD

– Hardware RAID10

– 1Gbps uplink

Please let us know if you have any questions/comments and enjoy!

The post Whitelabel ITSolutions – Coupon Code for 3GB VPS Plan with Free Migration! appeared first on Low End Box.

Any plan for custom engine generator Or standalone Engine Generator??

Hello sven or GSA staff
once im hiring a coder to write custom engine for me for private use but end up being spammed (it seems he use the web platform for him self ) ..Yes there a instructions in manual pages but for non tech person it seems not doable to do it by my self . there’s also post from GSA forum use he but it need 3rd party apps (zenoposter) which i don’t have
Is it possible or may be a suggestion for GSA Dev Adding Feature to generate .ini For custom web platform? or standalone program just like captcha breaker or platform identifier ..i don’t mind to buy the tools If the dev Planning to create one
Links generated by GSA nowdays is not good enough

How do I plan sessions that are still fun even if they don’t move the plot forward?

I’m fairly new to DMing, but I really enjoy it. My campaign is still pretty early in, and plot is moving forward pretty well; last session actually revealed a huge chuck of the relevant current events. Last session was also a nightmare; the entire party suddenly became hectic and chaotic (borderline murder-goblins). Next session is going to be pretty quiet in comparison; not really any new information, or any new goals (yet), and really, their characters are probably in trouble for causing several messes in town.

I’m not sure how to rectify this. How can I keep the players entertained while they’re not going anywhere or doing anything that progresses the plot? How do I make sure they’re having fun while the plot is at a standstill?

Half-Orc Fighter 5e ASI plan? [on hold]

My Half-Orc fighter is level 2 right now but once I reach 3 i’ll take the Samurai Subclass since I think it looks interesting. I have a general idea of what feats and stats I would like but im still a bit lost on what would be the most optimal choices I could make. My stats are

STR 17

DEX 12

CON 16

INT 8

WIS 14

CHA 18

I will mainly be using the Glaive and Greatsword I think so the GWM feat will work well since I already have the GWF fighting style. I also want the Polearm Master and Sentinel Feats since they all work together but outside of these 3 Feats I have no idea really. Getting STR to 20 is a good idea but should I just take a +2 then a +1 ASI or take 3 +1 STR Feats? or combinations of each like 2 +1 feats then a +1 ASI.

A Fighter has 7 opportunities for ASI as per the class so I thought I would ask what people recommended.I thought Orcish Fury and Magic Initiate seems fun I haven’t looked to Deep into it since there’s a ton of different feats out there and felt a bit lost.

Infervour To cover the value of this enlargement the plan

Infervour To cover the value of this enlargement the plan requires every body to have medical insurance with a of us and their education and day-to-day stories dictate to a terrific extent how they go approximately are better documented as effective. Now the Republicans and others do not typically like those ideas as " while we feel it's miles vital and we also have a cultural historical past that has engendered inside maximum folks the sensation…

Infervour To cover the value of this enlargement the plan