Why SQL server is not creating parallel execution plan although trying to use OPTION(MAXDO 20)

We have a UAT3 server hosted on VM with 8 sockets and 20 processer, we have similar UAT2 server hosted on the same VM with same configuration.

We are running a below query on both the server select recid from Table1 where nation=’AE’ both the server has same data and same structure.

UAT2 and UAT3 has default setting COST THRESOLD OF parallelism 5 and max degree of parallelism=0

IN UAT2 server parallel processing is happening. And it is taking 10 sec to complete. but UAT3 serial processing is happening because of that it is taking 3 mins 30 sec.

We compare both the UAT2 and UAT3 server configuration both are same. Not sure why SQL server is picking Parallel Execution in UAT2 but not in UAT3.

Cheapest Dedicated Server Hosting – Raisinghost!

Are you looking for Powerful dedicated servers at the best price? You can find The Next Generation Dedicated Servers at affordable prices with Raisinghost.com. We offer the cheapest dedicated servers with performance-optimized specifically for your hosting, mailing, and relevant use. Our range of cheap dedicated servers is starting from $75 per month. All servers are unmanaged and without monthly contracts. So buy your rental server today.

Best Range Server Starts from $75 and comes with features :

E3-1240 ( 2 Cores x 3.3 )
HDD Storage
16 GB RAM
2x HDD SATAII 2TB 7.20 Storage
4 Free IP Address
1Gbps uplink 10 TB traffic included
99 % Uptime Guarantee
On-demand IPMI
Full Root Access
No Restrictions
RDNS Available
SSH Access
Unmanaged Dedicated Server

Buy Now: https://raisinghost.com/cheapest-dedicat…osting.php

Thank you.

I want to know if the attact on my websites were successful based on the response code from my server

My websites got attacked with a bruteforce attack and this is the log I get from my server. Just want to confirm that they didn’t got any data

 20.96.201.62 - - [20/Jul/2021:09:21:19 -0700] "POST //xmlrpc.php HTTP/1.1" 200 401 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4240.193 Safari/537.36" 

How to securely share a link to a video on my server

I’ve created a web system for daycares on which the educators can upload videos of the kids, and then share those videos with the parents.

Currently the way I’m doing this is very simple. My system generates an email (to the parents) with a link to the video where it resides on my server. The educator clicks a "Send" button and the system fires off the email with the link.

For example: https://www.timesavr.net/companies/1453/dailyreports/randomvideoname.mp4

The video is not password protected, but the video name is randomly generated so impossible to guess. My question is, is this a security risk? And if so, what would be a better way to share these videos?

What are my limits and pre req’s for my Sql Server 2014 VM?

I have the following Virtual SQL Server (running in Windows Server 2016 Hypver-V environment): The VM is on one specific host shared with other vm’s and can be moved around on other hosts.

SQL Version: Microsoft SQL Server 2014 – 12.0.2269.0 (X64) Jun 10 2015 03:35:45 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.3 (Build 14393: ) (Hypervisor)

My VM has the following specs: 1 virtual Socket 8 Virtual Processors 500 GB SQL DB

enter image description here

The dev’s are breaking my bowling balls as they mention that the app in production is too slow because we are not allocating enough resources VM-wise.

However, I thought that 8 Virtual Procesors is the maximum no? I found a PDF on the following URL: https://download.microsoft.com/download/B/4/E/B4E604D9-9D38-4BBA-A927-56E4C872E41C/SQL_Server_2014_Licensing_Guide.pdf

but this looks so psychedelic that I can’t even understand half of what’s written.

Is there a table somewhere for noob system admins on max specs wise you can give to virtualized SQL Servers?

Ola hallengren SQL Server Index and Statistics Maintenance solution

We are using the Ola hallengren SQL Server Index and Statistics Maintenance solution from the past 6 months in our production system. Script is only used for Update Statistics not Index maintenance. Job used to take about 90-120 mins to complete which was completely normal considering the database size(1.8TB). All of a sudden the job started to take about 5-6hrs to complete from the past couple of weeks. We haven’t made any changes to the system. Each Statistics used to take less than 5 secs before now they take about 60-250 secs to complete. All this happened within a couple of days, not gradually. We are using SQL Server Enterprise edition.

Has anyone experienced this kind of issue before? Any suggestions are greatly appreciated.

Below are the parameters used in SQL job.

EXECUTE dbo.IndexOptimize –@Databases = ‘ALL_DATABASES’, @Databases = ‘User DB’, @FragmentationLow = NULL, @FragmentationMedium = NULL, @FragmentationHigh = NULL, @UpdateStatistics = ‘ALL’, @OnlyModifiedStatistics = ‘Y’, @MAXDOP=2, @Indexes=’ALL_INDEXES’, @LogToTable=’Y’ –,@Indexes=’ALL_INDEXES,-%.dbo.eventhistory,-%.dbo.eventhistoryrgc’

Best Regards, Arun

Detect what version of SQL Server Express engine is available before connection?

I would like to detect what version of SQL Server Express engine is available so that I can connect either to the (localdb)\v.11 (SQL Server 2012 per https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/hh510202(v=sql.110)?redirectedfrom=MSDN#Anchor_1) or (localdb)\MSSQLLocalDB (SQL Server 2014 and up per https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql-server-ver15&redirectedfrom=MSDN&viewFallbackFrom=sql-server-2014#Anchor_1) instance name when attempting to attach a file in the connection string using the AttachDBFileName= mechanism.

I would most likely want to do it from Powershell in some manner, but whatever method is reliable, I can use. I do know that sometimes a LocalDB connection can be a bit slow as it attaches the file and starts up on demand, so I have in the past been pretty lenient on the connect timeout for these LocalDB connections compared to the real SQL Server connections, so I would prefer not trying to connect and waiting for timeout, since I think I’ve already got an exaggerated timeout just for normal successful connection.

Custom Menu not working on Test Server

I need to add custom menus to the footer of a WordPress Site. Following a tutorial I updated my files as follows:

functions.php

function register_my_menus() { register_nav_menus(     array(          'product-range' => __( 'Product Range' ),          'industry-types' => __( 'Industry Types' ),          'services' => __( 'Services' )      )  ); } add_action( 'init', 'register_my_menus' ); 

footer.php

<div class="container">             <div class="col-3" style="float:left"><h3>Product Range</h3> <?wp_nav_menu( array( 'footer' => 'product-range', 'container_class' => 'footer-menu' ) ); ?></div>             <div class="col-3" style="float:left"><h3>Industry Type</h3>                 <?wp_nav_menu( array( 'footer' => 'industry-type', 'container_class' => 'footer-menu' ) ); ?></div>             <div class="col-3" style="float:left"><h3>Services</h3>                 <?wp_nav_menu( array( 'footer' => 'services', 'container_class' => 'footer-menu' ) ); ?></div>             <div class="col-3" style="float:left"><h3>Address/Social Media Stuff</h3></div> </div> 

This worked fine on my local development machine — I ended up with additional menus in the CMS that I could add to as required. However when I uploaded my custom theme to the test server I saw the following where the menu should be:

product-range', 'container_class' => 'footer-menu' ) ); ?>

Can anybody tell me why this isn’t working here?

The SQL Server replication subscriber cannot start: ‘No agent status information is available.’

I am trying to run merge replication of the database between two servers (both are SQL Server version 15). Both servers are in the domain. On both I am logged using this domain account (all server roles enabled like sysadmin, serveradmin, setupadmin).

I created publication using wizard and selected following options:

  • ‘Merge publication’
  • ‘SQL Server 2008 or later’
  • Then I selected one table as object to publish
  • No filters
  • I unchecked ‘Schedule the Snapshot Agent to run at the following times’
  • Snapshot Agent: ‘Run under the following windows account’ – I entered my domain account + password
  • Connect to the publisher: ‘By impersonating the process account’

Publication has been created successfully.

I created subscription using wizard and selected following options:

  • Publication dialog – I have selected publication which I have just created
  • ‘Run each agent at its Subscriber (pull subscription)’
  • I have selected the database on the destination server (I created it before running subscription wizard)
  • Merge agent security dialog: again I have entered my domain credentials, Connect to Distributor: ‘by impersonating…’, Connect to Subscriber: ‘by impersonating…’
  • Synchronization schedule dialog: ‘Subscriber’, ‘Run continuously’
  • Initialize Synchronizations dialog: ‘Initialize’, ‘At first synchronization’
  • Subscription Type: ‘Client’, ‘First to Publisher wins’

Subscription has been created successfully

But when I right click on subscriber and select ‘View synchronization status’ the message appears:

'No agent status information is available.' 

and when I try to click ‘Start’ button then the error message appears:

'The agent could not be started. SQLServerAgent Error: Request to run job DEV-SQL1\DB1-ag_publ5-ag_publication_5_2-DEV-SQL2\DB1-ag_subs5- 0 (from User sa) refused because the job is already running from a request by User sa. Changed database context to 'ag_subs5'. (Microsoft SQL Server, Error: 22022) ' 

I created snapshots on the publisher site, stop the related job on the subscriber site and then pressed ‘Start’ button in ‘View synchronization status’ dialog, but the result is always as described above.

Any suggestion how can I start my subscriber are kindly appreciated.

Major Performance Difference Between SQL Server Developer and Standard Edition

So experiencing an interesting performance issue. We found a query that runs in around 6 seconds in our dev environment. However, when deployed to production (same data / same hardware) it takes around 36 seconds to execute. After doing comparison and side-by-side testing (confirmed that all settings are identical) it appears that the only difference is that development is using the developer edition and production uses standard (both SQL Server 2019 fully patched).

I suspect some of the features that are available in development (i.e. Enterprise edition) are causing the performance benefit in dev but don’t know where to go from here. I am fairly confident in this because I provisioned a separate server did the test in Dev (6 seconds) and then reinstalled with Standard and it went to 37.

Any idea what feature(s) are likely causing this difference? Hoping knowing that will help me performance tune this query more (it is pretty ugly at the moment) in Standard Edition since we can’t afford Enterprise in production.

Development Execution Plan: Plan

Production Execution Plan: Plan

Thanks!