Skip to main content
144 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
24 views

On Windows Server 2016 and with SQL Server 2019 (v15.0), the tempdb file size is huge at about 80GB and it is divided into many files such as: tempdb.mdf, tempdb_mssql_2.ndf tempdb_mssql_3.ndf ... ...
Orgil's user avatar
  • 317
3 votes
1 answer
218 views

I have a very simple query that I am testing by running ad-hoc. The execution plan indicates that data is spilling into tempdb because of poor estimates. I have been unable to resolve any of the three ...
James's user avatar
  • 33
0 votes
1 answer
379 views

In my SQL Server, I have 9 user databases and I would like to find out which user database is using how much resources in tempdb, which database is using more and which less, and furthermore, I would ...
Zakir Hossain's user avatar
  • 1
1 vote
0 answers
194 views

I'm trying to troubleshoot what is causing timeouts when querying specific table in production. I suspected that there are some uncommitted transactions, so I ran following query: SELECT trans....
Liero's user avatar
  • 27.8k
0 votes
0 answers
741 views

We have successfully upgraded our server version to SQL Server 2019. One of the expected features that we dreamed about was memory-optimized TempDB metadata and we turned it on, first we decided to ...
Orlandis's user avatar
  • 1
0 votes
1 answer
5k views

I have a server that is getting full, due to some temp table processing. We found that our tempdb file was at 33.8 GB and there was a another file at 33.8 GB called tempdb_mssql_2 Now then, we ran the ...
Mark Johnson's user avatar
  • 665
0 votes
1 answer
366 views

I got some problems with my SQL Server. Some external queries write into the Temp db and every 2-3 days it is full and we have to restart the SQL database. I got who is active on it. And also we can ...
Sascha S's user avatar
  • 1
0 votes
1 answer
180 views

I am selecting the name, size, growth, maxsize, and physical_name from sys.master_files and sys.database_files. I've noticed that when I do this the growth value will be reported as 8192MB on both ...
Tanner's user avatar
  • 3
0 votes
0 answers
1k views

It takes about 3 days for the transaction log (tempdb) to get to the size of a production database (~130 GB). It has come up recently (~2 weeks ago) and there had been no problems up to that point. I'...
pr0t's user avatar
  • 1
0 votes
2 answers
2k views

In T-SQL, it's normally best to name all constraints you create, including check constraints. alter table mytable with check add constraint myconstraint check (mycol > 0) If you don't provide ...
Ed Avis's user avatar
  • 1,622
0 votes
0 answers
327 views

An application vendor representative asked me to grant dbowner access to tempdb for their application login; to be able to create objects in tempdb without "#" or "##" prefixes. I ...
Farshid SQLServer's user avatar
  • 3
1 vote
0 answers
556 views

My question is the following: Scope: I am currently using Microsoft Dynamics Ax 2012 R3 and my database has the following settings in the properties of the tempdb in Microsoft Sql Server 2012. ...
Pablo Sanchez's user avatar
  • 31
0 votes
0 answers
137 views

I have a perfomance issue regarding the update of Synonym table. I have two SQL Servers: Server A (2017 DEV) Server B (2008 R2 DEV) and they communicate through linked Server (collation compatible = ...
Emka's user avatar
  • 350
0 votes
0 answers
469 views

I need to insert a very large number of rows into a table from a query, which puts me at risk of exceeding space on tempdb. I am in need of a solution that can avoid this issue, and am considering the ...
baobobs's user avatar
  • 723
0 votes
2 answers
94 views

How can I alter tempdb inside a select? I want a single query is that possible? SELECT cust_ac_no, ord_no, ref_no, net_svc_id, job_type, ord_status, ord_status_date, ord_crt_date INTO tempdb.....
Drin's user avatar
  • 21
0 votes
0 answers
123 views

I have some jobs (stored procedures ) running in SQL server. The jobs are working good every day. The point is that the database should increase the size every day until next month but since 30/09 ...
Luxpbi's user avatar
  • 23
0 votes
0 answers
1k views

I've been investigating high write latency figures in tempdb on a data warehouse server (about 600ms!). As part of that investigation, I've identified a query that is causing significant internal ...
FrugalShaun's user avatar
  • 176
2 votes
3 answers
2k views

In our solution we are creating some physical tables in "tempDB" for an activity. But recently we are facing an issue where these physical tables are getting deleted automatically. We would like to ...
Prakash's user avatar
  • 555
-1 votes
1 answer
522 views

When I run the below code on a Temp database it does work, but not when I run it on a normal table. Very weird and not sure what I am missing. CREATE TABLE #Test (Username VARCHAR(20)) insert into #...
Etienne's user avatar
  • 7,261
4 votes
2 answers
33k views

Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'. Create the necessary space by dropping objects in the filegroup, adding additional files ...
Navin's user avatar
  • 73
0 votes
0 answers
135 views

following situation: We have an azure server with db and the TempDB drive ran full. At this moment we could find a process with much resources need in activity monitor. The process was not killable ...
Dominik's user avatar
  • 13
0 votes
0 answers
81 views

We saw some substantial log growth on both tempdb and one of the user databases. Our database is in Snapshot isolation and we take transaction log backups every 15 minute. First 'TL log full error ...
Nish's user avatar
  • 21
0 votes
0 answers
522 views

We find, for our application, locating TempDB files on RAMDisk improves performance significantly. But we don't want to allocate more RAM to RAMDisk than necessary. Nor do we want SQL Server to fail ...
Paul Davis's user avatar
  • 23
1 vote
1 answer
952 views

I have a query which retrieves around 184K rows and stores into Temporary table. Now, In second query I am first retrieving all the data from Temporary table and pivoting it. While pivoting I am ...
Jay Desai's user avatar
  • 871
1 vote
0 answers
36 views

My tempdb data file has grown significantly in size and I'd like to get an understanding of who made the change, this is a fairly recent event and there are no autogrowth events in the disk usage ...
Krishn's user avatar
  • 893

1
2 3