question

IshanTalathi-1044 avatar image
0 Votes"
IshanTalathi-1044 asked CarrinWu-MSFT commented

SQL Server Cannot Spawn Increamental thread

Hello,

One of our SQL Server fails frequently with the below error


95534-2021-05-11-13-16.png


95574-image-pasted-at-2021-5-11-13-06.png

EDIT1:

 SELECT @@VERSION
    
 Microsoft SQL Server 2012 - 11.0.5058.0 (Intel X86) 
     May 14 2014 16:44:52 
     Copyright (c) Microsoft Corporation
     Standard Edition on Windows NT 6.3 <X64> (Build 14393: ) (WOW64)




sql-server-general
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Looks problematic. As a starting point, can you post the output of "SELECT @@version"?

0 Votes 0 ·

As per your suggestion added the version in edit 1

0 Votes 0 ·

Microsoft SQL Server 2012 - 11.0.5058.0 (Intel X86)

You are on SP2, better install latest SP 4 + CU, before you go on. Why have you installed SQL Server as 32 bit application; not the best idea nowadays?

https://sqlserverbuilds.blogspot.com/

0 Votes 0 ·

Yeah, and on SQl 2012, 32-bit version did not have AWE support like earlier versions did, you can have at max 4GB of RAM for SQL Server. Which could explain the error message.

Uninstall and install the 64-bit version instead.

0 Votes 0 ·

Hi @IshanTalathi-1044, I saw the server error: 17120 from your screenshot, does the error log contains the following errors: 17182 or 17826?

0 Votes 0 ·

Hi @IshanTalathi-1044, we have not get a reply from you. Any update for this issue?

0 Votes 0 ·

0 Answers