This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 46%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Hi Team,
Today we are facing a strange issue.
Like even simple create statement is not executing on this DB
Version: SQL Server 2016 with CU 17 on Windows Server 2012 VM
this DB is around 4.5 TB (Part of Always on) no DR.
example:
CREATE TABLE Persons (
PersonID int,
LastName varchar(255),
);
this statement ran for 8 mins still not completed and i canceled.
Don't know what's going on.
This issue was started in the past 2 days and no recent changes.
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
Answer accepted by question author
Sounds like a blocking issue, like a process holding a lock on system tables.
You could use my beta_lockinfo to investigate the blocking. Start the CREATE TABLE statement and look for rows with !! in the BlkLvl column. That is the root blocker.
How to run beta_lockinfo?
i ran this query and took just few seconds and didn't get any output instead of got successfully completed.
I ran this query on master DB.
later i ran below query but . but results are empty
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP (1000) [spid]
,[command]
,[login]
,[host]
,[hostprc]
,[endpoint]
,[appl]
,[dbname]
,[prcstatus]
,[ansiopts]
,[spid_]
,[trnopts]
,[opntrn]
,[trninfo]
,[blklvl]
,[blkby]
,[cnt]
,[object]
,[rsctype]
,[locktype]
,[lstatus]
,[ownertype]
,[rscsubtype]
,[waittime]
,[waittype]
,[top5waits]
,[spid__]
,[cpu]
,[physio]
,[logreads]
,[memgrant]
,[progress]
,[tempdb]
,[now]
,[login_time]
,[last_batch]
,[trn_start]
,[last_since]
,[trn_since]
,[clr]
,[nstlvl]
,[spid___]
,[inputbuffer]
,[current_sp]
,[curstmt]
,[queryplan]
,[rowno]
FROM [master].[guest].[beta_lockinfo]
How to run beta_lockinfo?
It is as simple as:
EXEC beta_lockinfo
The table you selected from is only used when you use archive mode. This is something you could use if you want to us to look at the output. As for how to use archive mode and share data with others, see the page that I pointed you to.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 17%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI1%3C/text%3E%3C/svg%3E)
Hi @Vijay Kumar
Here is the official article about how to investigate the blocking，please check out this thread：https://learn.microsoft.com/en-US/troubleshoot/sql/performance/understand-resolve-blocking
Best Regards,
Isabella
If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 56.00000000000001%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBZ%3C/text%3E%3C/svg%3E)
Hi，@Vijay Kumar
Welcome to Microsoft T-SQL Q&A Forum!
If you are recreating a dropped table then I feel that the definition of the table must conform to the foreign key constraints referencing it.
It must have the correct column names and types, and must have an index on the referenced key. If not, does the system prompt any error message or code?
Best regards,
Bert Zhou
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.