Sfrgttk

Sensor logger for Raspberry Pi in a stratospheric probe

Is the percentage symbol a constant?

Is the fingering of thirds flexible or do I have to follow the rules?

Why didn't Tom Riddle take the presence of Fawkes and the Sorting Hat as more of a threat?

Can me and my friend spend the summer in Canada (6 weeks) at 16 years old without an adult?

Is there any danger of my neighbor having my wife's signature?

Do we still track damage on indestructible creatures?

Why do single electrical receptacles exist?

Democratic Socialism vs Social Democracy

RS485 using USART or UART port on STM32

How do I avoid the "chosen hero" feeling?

Is the symmetric product of an abelian variety a CY variety?

Possible issue with my W4 and tax return

Other than edits for international editions, did Harry Potter and the Philosopher's Stone receive errata?

Homeostasis logic/math problem

Is there a non trivial covering of the Klein bottle by the Klein bottle

What can I do to encourage my players to use their consumables?

Is it legal to point a domain to someone else's ip (website)?

How can I prevent an oracle who can see into the past from knowing everything that has happened?

How can I take a waterfall's effect on a jump into consideration mechanically?

Does the US government have any planning in place to ensure there's no shortages of food, fuel, steel and other commodities?

Critique vs nitpicking

Is it possible to rotate the Isolines on a Surface Using `MeshFunction`?

Isn't a semicolon (';') needed after a function declaration in C++?

SQL Server CPU Issues

SQL Server Connectivity IssuesA Difficult Case of “A transport-level error has occurred when receiving results from the server” SQL ServerSQL Server Memory IssuesCannot tune database any further; what next?MS SQL Server Express CPUSQL Server 2016 slow restoreBest Way To Migrate Existing Production Database To New Physical Storage StructureUnderutilized CPU on SQL serverHow do I change a processor count on a stopped SQL Server instance?SQL Server Blocking issues

0

We've inherited some SQL server 2014 databases, they are running on Azure IaaS. We're getting complaints about performance and trying to get a grip on it. We're starting to look at CPU performance, and run the following test:

DECLARE @Loops INT SET @Loops = 1

DECLARE @CPU INT SET @CPU = @@CPU_BUSY

DECLARE @StartDate DATETIME SET @StartDate = GETDATE()



WHILE @Loops <= 100000

BEGIN

    IF COALESCE('123', '456') = '456'  

            PRINT 1

    SET @Loops = @Loops + 1   

END



PRINT 'Total CPU time: ' + CONVERT(varchar, @@CPU_BUSY - @CPU)  

PRINT 'Total milliseconds: ' + CONVERT(varchar, DATEDIFF(ms, @StartDate, GETDATE())) 

PRINT ''   

GO

On Production machine, 16 Virtual Processors (20 to 30% busy), we get the following result:

Total CPU time: 1150

Total milliseconds: 13473

On test machine, 4 Virtual Processors (also around 20 to 30% busy) we get the following:

Total CPU time: 2

Total milliseconds: 1183

I've tried running a few benchmarks on the production machine, but they don't show any problems, and always show the production machine CPU at least twice as powerful as test machine.

Is there some SQL Server setting that might be configured wrongly? Any idea how to troubleshoot this issue?

Note the 'problem' database is running always on Availability Group, we are wondering if that may be a factor here.

sql-server

share

asked 4 mins ago

PatrickPatrick

1563

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Have you checked MAXDOP and Cost Threshold for Parallelism setting on your SQL server?
  
  – Learning_DBAdmin
  2 mins ago
  

  
  
  
  

add a comment | 

0

We've inherited some SQL server 2014 databases, they are running on Azure IaaS. We're getting complaints about performance and trying to get a grip on it. We're starting to look at CPU performance, and run the following test:

DECLARE @Loops INT SET @Loops = 1

DECLARE @CPU INT SET @CPU = @@CPU_BUSY

DECLARE @StartDate DATETIME SET @StartDate = GETDATE()



WHILE @Loops <= 100000

BEGIN

    IF COALESCE('123', '456') = '456'  

            PRINT 1

    SET @Loops = @Loops + 1   

END



PRINT 'Total CPU time: ' + CONVERT(varchar, @@CPU_BUSY - @CPU)  

PRINT 'Total milliseconds: ' + CONVERT(varchar, DATEDIFF(ms, @StartDate, GETDATE())) 

PRINT ''   

GO

On Production machine, 16 Virtual Processors (20 to 30% busy), we get the following result:

Total CPU time: 1150

Total milliseconds: 13473

On test machine, 4 Virtual Processors (also around 20 to 30% busy) we get the following:

Total CPU time: 2

Total milliseconds: 1183

I've tried running a few benchmarks on the production machine, but they don't show any problems, and always show the production machine CPU at least twice as powerful as test machine.

Is there some SQL Server setting that might be configured wrongly? Any idea how to troubleshoot this issue?

Note the 'problem' database is running always on Availability Group, we are wondering if that may be a factor here.

sql-server

share

asked 4 mins ago

PatrickPatrick

1563

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Have you checked MAXDOP and Cost Threshold for Parallelism setting on your SQL server?
  
  – Learning_DBAdmin
  2 mins ago
  

  
  
  
  

add a comment | 

We've inherited some SQL server 2014 databases, they are running on Azure IaaS. We're getting complaints about performance and trying to get a grip on it. We're starting to look at CPU performance, and run the following test:

DECLARE @Loops INT SET @Loops = 1

DECLARE @CPU INT SET @CPU = @@CPU_BUSY

DECLARE @StartDate DATETIME SET @StartDate = GETDATE()



WHILE @Loops <= 100000

BEGIN

    IF COALESCE('123', '456') = '456'  

            PRINT 1

    SET @Loops = @Loops + 1   

END



PRINT 'Total CPU time: ' + CONVERT(varchar, @@CPU_BUSY - @CPU)  

PRINT 'Total milliseconds: ' + CONVERT(varchar, DATEDIFF(ms, @StartDate, GETDATE())) 

PRINT ''   

GO

On Production machine, 16 Virtual Processors (20 to 30% busy), we get the following result:

Total CPU time: 1150

Total milliseconds: 13473

On test machine, 4 Virtual Processors (also around 20 to 30% busy) we get the following:

Total CPU time: 2

Total milliseconds: 1183

I've tried running a few benchmarks on the production machine, but they don't show any problems, and always show the production machine CPU at least twice as powerful as test machine.

Is there some SQL Server setting that might be configured wrongly? Any idea how to troubleshoot this issue?

Note the 'problem' database is running always on Availability Group, we are wondering if that may be a factor here.

sql-server

share

asked 4 mins ago

PatrickPatrick

1563

DECLARE @Loops INT SET @Loops = 1

DECLARE @CPU INT SET @CPU = @@CPU_BUSY

DECLARE @StartDate DATETIME SET @StartDate = GETDATE()



WHILE @Loops <= 100000

BEGIN

    IF COALESCE('123', '456') = '456'  

            PRINT 1

    SET @Loops = @Loops + 1   

END



PRINT 'Total CPU time: ' + CONVERT(varchar, @@CPU_BUSY - @CPU)  

PRINT 'Total milliseconds: ' + CONVERT(varchar, DATEDIFF(ms, @StartDate, GETDATE())) 

PRINT ''   

GO

Total CPU time: 1150

Total milliseconds: 13473

Total CPU time: 2

Total milliseconds: 1183

share

asked 4 mins ago

PatrickPatrick

1563

share

asked 4 mins ago

PatrickPatrick

1563

asked 4 mins ago

PatrickPatrick

1563

asked 4 mins ago

PatrickPatrick

1563