Stack Overflow
Stack Overflow

Questions tagged [tempdb]

138 questions
0
votes
1 answer

How to add the tempdb data files automatically depending on the number of CPU core count available

If there are less number of data files in the tempdb then we would have noticed that there could be issue in performance and queries will go for pagelatch_up waitType. And we need to manually add the data files by checking the number of cores…
Adarsh H D Dev
  • 588
  • 7
  • 29
0
votes
1 answer

Fixed Size TempDB (800Gb), MERGE into very large table failing due to space, is this a limitation of merge?

Thanks for reading, am a bit confused by this, think it is down to the size of TempDB, but unsure why it is happening in this case: I have a MERGE statement: DECLARE @LastUpdate DATETIME SELECT @LastUpdate = ISNULL(MAX(LastUpdate),'1900-01-01') FROM…
Rickd43
  • 1
  • 1
0
votes
0 answers

Update Synonym Table with values stored in tempdb

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 = TRUE). I have a log table (let's say T) on…
Emka
  • 340
  • 6
  • 16
0
votes
1 answer

tempdb usage at Azure SQLDW

Can I track or get a report every 30 minutes to sum the tempdb usage by user id for AZureSQlDW? Any suggestions are highly appreciated Thanks, Cherishma.
princy
  • 3
  • 2
0
votes
0 answers

SQL Server - Avoiding tempdb storage issues using cursors

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 use of cursors as a potential solution. Within…
user1185790
  • 623
  • 8
  • 24
0
votes
1 answer

Configuration for ASPState database

Persistent ASP Session store can reside in either "tempdb" or "aspstate" database in SQL Server 2005. The sqlConnectionString parameter, in sessionState doesn't specify this (example below). How is this resolved?
Vivek Singh
  • 1
0
votes
2 answers

Alter ADD tempDB inside SELECT?

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..xtiankwiksetreport ALTER table…
Drin
  • 21
  • 4
0
votes
0 answers

Tempdb. There is no enough space on the disc encountered

Does anyone know what really happened here? All of the sudden database was not accessible. How to find transactions that cause tempdb filled up? Seems like it happened right after SQL profiler trace has stopped. Can this cause the issue?
Serdia
  • 4,242
  • 22
  • 86
  • 159
0
votes
0 answers

Jobs working correctly but tempdb not modified

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 the size as not increased. I have seen that the…
Luxpbi
  • 23
  • 5
0
votes
1 answer

How to exclude tempdb from sp_MSforeachdb?

Below I have a code to get info about t-log backups for each database in the server. I want to exclude tempdb from this list. exec sp_MSforeachdb 'SELECT server_name, sysdb.name AS DatabaseName, bkup.user_name AS [User], ceiling(bkup.backup_size…
Rauf Asadov
  • 113
  • 1
  • 3
0
votes
0 answers

SQL Server TempDB - Will a Hash Match operator always cause tempdb allocations?

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 object allocation in tempdb (about 8GB worth) Now,…
FrugalShaun
  • 166
  • 7
0
votes
1 answer

Sql Server Shrinking temp db mdf and ndf

So my question is that even after the job runs and I'm enforcing the mdf (main tempdb file) to be shrunk to about 10mb or so why is it NOT doing it? I have tried to run this job after my most heavy lifting ETL jobs (that pulls from various sources…
junketsu
  • 533
  • 5
  • 17
0
votes
0 answers

SSRS Report Error Invalid Object Name System.Data.SqlClient.SqlException: Invalid object name 'tempdb.dbo.TEMP_ID_XXXX'

I am facing a weird problem and I would be glad if anyone can help me. In our company we use SSRS to send daily Reports to the Same Management. We Have 3 Types of Reports, which of 3 is executed more times with different parameters. The first it is…
Gio
  • 1
  • 2
0
votes
1 answer

Linking checkboxes in a form back to a string property of a class in MVC/Razor Pages

I am creating a form for an assignment where when the form is completed the data entered for each applicant is saved to a DB. Each property for the applicants is created in a Applicant class, some are required some not. As part of this I need to ask…
Boots09
  • 3
  • 1
0
votes
0 answers

TempDB drive Full - Procedure needs much performance?

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 cause the rollback couldn't be done cause of the…
Dominik
  • 13
  • 3
1 2 3
…
9 10