Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [troubleshooting]

64 questions
23
votes
2 answers

What can cause a mirroring session to timeout then failover?

We have two production SQL Servers running SQL Server 2005 SP4 with cumulative update 3. Both servers run on physical machines that are identical. DELL PowerEdge R815 with 4 x 12 core CPUs and 512GB (yes GB) of ram, with 10GB iSCSI SAN connected…
Hannah Vernon
  • 70,928
  • 22
  • 177
  • 323
20
votes
4 answers

how to query SSISDB to find out the errors in the packages?

I have seen this question SSIS 2012 - How to Query Currently Running Packages in T-SQL? It gives me the following script: SELECT E.execution_id , E.folder_name , E.project_name , E.package_name , E.reference_id , E.reference_type , …
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
15
votes
3 answers

Sleeping SPID blocking other transactions

I'm really having trouble tracking down some blocking we are experiencing. The root blocking SPID's status is 'sleeping', the cmd is 'AWAITING COMMAND', and the sqltext is SET TRANSACTION ISOLATION LEVEL READ COMMITTED. When I view the Top…
Brad
  • 943
  • 3
  • 9
  • 24
13
votes
4 answers

Find all IP's or users who access a specific SQL Server

Let's say I found a SQL Server and I have no idea which applications connect to it. Maybe I find one application but I am not sure if it is the only one using it. Is there a nice way of finding all distinct connections?
RayofCommand
  • 1,373
  • 5
  • 15
  • 31
12
votes
2 answers

What is hot spotting in the context of adding files to tempdb?

I'm trying to find out whether it is possible to add tempdb files to a SQL Server without having to restart the SQL Server service. I saw this answer here on Database Administrators: Tempdb Add files require Restart And one answer states: ADD -…
jrdevdba
  • 288
  • 2
  • 7
11
votes
5 answers

How to fix a messed up replication on MS SQL Server

I restored a database from a backup. The database uses replication to publish to a different server. Assuming the database restore would break the replication, I tried to delete the replication and re-create it (we have a script to re-create it from…
TallGuy
  • 371
  • 1
  • 2
  • 8
10
votes
4 answers

SSRS error "something went wrong please try again later" in web portal

I have a brand new installation of SQL Server Reporting Services 2019 on top of MSSQL 2019 Enterprise CU1. SSRS has been installed and configured using default settings, apart from the service account it should use. Both AD and MSSQL instance are…
Bartosz X
  • 503
  • 1
  • 5
  • 17
7
votes
4 answers

How to troubleshoot orm queries interfering with other applications

Well, it's hypothetical scenario but what I'm trying to understand is the path to go from a post-morten log (say, an SQL Server Profiler trace) to identify the code on a ORM situation. To make it not too vague, consider an scenario like that: SQL…
Fabricio Araujo
  • 957
  • 7
  • 14
6
votes
1 answer

Troubleshooting Postgresql spatial query failure. Next steps?

We have a set of spatial queries that are failing and I'm struggling with troubleshooting them. I suspect that we're running into some bug, but I'd like to nail things down a bit better so as to be sure and also so that the resulting bug report is…
gsiems
  • 3,413
  • 2
  • 23
  • 26
6
votes
1 answer

sp_WhoIsActive vs sp_BlitzFirst @ExpertMode = 1

I use sp_WhoIsActive and sp_BlitzFirst (with ExpertMode paramter set to 1) to get an overview of what is happening on the SQL Server in real time. I find these to be an upgrade on sp_who, sp_who2 etc... Can anyone explain what, if any difference…
SE1986
  • 2,142
  • 4
  • 30
  • 61
6
votes
4 answers

"SSIS Evaluation Period Has Expired" on Dev Instance?

I recently started receiving the following error on a dev server. At one point SQL Server 2016 CTP was installed here but we've upgraded since then. I've tried uninstalling / reinstalling SSIS as well as repairing it. Reboots occurred along the way.…
SQL_Deadwood
  • 841
  • 3
  • 7
  • 24
6
votes
1 answer

How to Start Express SQL Server instance in Single user mode?

I want to start my SQL Server Express instance in single user mode to do some troubleshooting such as restoring the Master database. I am unable to find the "Startup Parameter" options in SQL Server Configuration Manager. I have found some blogs…
Md Haidar Ali Khan
  • 6,523
  • 9
  • 40
  • 62
6
votes
2 answers

Increase memory limit when server is stopped

There was a local SQL Server 2012 instance. Once memory has decreased to critical 128 MB and then has stopped by me. I can not start it (idea: not enough memory). Is it possible to increase this limit in config file or in system registry?
Aleksandro M Granda
  • 163
  • 1
  • 3
4
votes
1 answer

How can a connection for one DB block a connection to another DB in SQL Server?

We have an interesting scenario. For weeks, we have been experiencing 'outages' on SQL Server 2008 -- where our websites have slowed to a crawl and mass timeouts for all customers who have DB's living on that server. When looking at SQL Server for…
tresstylez
  • 143
  • 5
3
votes
1 answer

Troubleshooting a slow performing encrypted stored procedure

I have a stored procedure which is part of a vendor supplied system. The stored procedure is encrypted so we can't see the code. The stored procedure has all of a sudden started to run slow. The first thing I would look to do is look at the…
SE1986
  • 2,142
  • 4
  • 30
  • 61
1
2 3 4 5