Skip to main content

Questions tagged [troubleshooting]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
43 views

SSRS - Microsoft.ReportingServices.Diagnostics.Utilities

I am troubleshooting an error in SSRS we want to alter a subscription and set it to the next 5 min from now, but when it gets there it does not run. other than that, I see these error messages in the ...
Marcello Miorelli's user avatar
0 votes
1 answer
68 views

what sql server is holding in the used memory?

I have a query that shows me how much memory sql server is using, the settings like max memory and min memory, cpu, etc. here is the query: --===========================================================...
Marcello Miorelli's user avatar
0 votes
0 answers
31 views

Having an issue with duplicates after I insert into my suppression table

Hey guys thank you so much in advance for the help. I do mailings every 3 months. I know I am missing records where there is a null. I delete those so that's not the issue I noticed one of my queries ...
ocean waves's user avatar
1 vote
0 answers
427 views

Unable to create and install pgAgent service

I'm trying to install pgAgent on my device. During the installation using the stackbuilder, the last step requires me to add the operating system username and password as below: However, after ...
Abhinav Shenoy's user avatar
0 votes
1 answer
67 views

Average Density & cardinality estimation

In a large web application we had a query that was running slow in code, that seemed to be working blazing fast in SSMS. After checking the basics like the same SET options, we found that there was ...
Hugo Delsing's user avatar
0 votes
1 answer
145 views

Operational stats mention the same table twice, what does this mean?

While investigating why my application mentions deadlocking, I fell upon this question, whose answer mentions an SQL query, showing operational logs. However, the results of that query contain the ...
Dominique's user avatar
  • 581
1 vote
3 answers
390 views

Find which IP added a specific record to a table in SQL Server

Let's say I have an SQL Server running on Azure and multiple applications add records to it. The problem is that some records come from an unknown application. Is there a nice way of finding which IP ...
Dimitrios Arampatzis's user avatar
1 vote
0 answers
415 views

Potential causes for unusually long queries (postgres)

Recently we've noticed some SELECT queries taking an unusually long time to complete and are a bit stumped on what the reason could be. Looking at DB (and server) CPU and IO during the time the ...
tmns's user avatar
  • 11
2 votes
2 answers
3k views

How do I find out what's causing processes to wait for table flush?

I'm currently using MariaDB 10.3 and am troubleshooting this case where threads will start to build up until the MySQL service eventually has to be restarted. I was able to capture the process list ...
kenshin9's user avatar
  • 119
1 vote
0 answers
258 views

Why do some SQL Server databases go into a "Recovery Pending" state after shutting down / restarting on Linux?

I built a secondary PC from old parts as a server for SQL Server databases and I went with Linux/Ubuntu 20.04 because it's free. I knew it would not be easy to set this up (I'm rather a Windows user) ...
Ha'gel's user avatar
  • 19
0 votes
2 answers
1k views

When queries start executing on standby server the replay lag starts to increase

I have a two servers with following specs: 8 vCPU, 32768 MB RAM, 640 GB SSD The master Postgres 13.3 database (db1) is installed on first server (Ubuntu 16.04.7) with the following config: ...
Andrei's user avatar
  • 111
1 vote
2 answers
1k views

DBA - Checklist Question- TempDB Is Full

I'm trying to create some checklists for troubleshooting various issues, in this case, when TempDb is full. I'd like a prioritized repeatable process where possible to help me out in a hurry. When ...
JM1's user avatar
  • 253
2 votes
0 answers
625 views

Troubleshoting slow running queries/jobs in Azure Databricks

I have Azure Databricks workspace with cluster configured to run Standard 6.4 runtime (Apache Spark 2.4.5, Scala 2.11). Cluster uses shared metastore (Azure MySQL). I'm trying to figure out possible ...
Mike's user avatar
  • 747
0 votes
1 answer
908 views

PostgreSQL CPU 100% after configure Wal log shipping hot standby

I have configured Hight Avaliabily WAL Log Shipping Hot Standby (SSL) with one node. But after I configure, both hosts (primary and secondary) take 100% CPU usage. The most strange is because I have ...
Leonardo Lacerda's user avatar
0 votes
1 answer
84 views

Case overcounting what is expected

So I am attempting to setup a query that can track actions that are automated within our web system. The first thing I am attempting to check is the reminders we are sending out to customers. I have ...
stan's user avatar
  • 1
0 votes
1 answer
2k views

dbmail failing to send intermittently [duplicate]

We have a SQL Agent job that runs daily that sends emais out to our drivers with their schedules for the next day. For 85% of drivers, the emails are not getting out of the SQL server. The other 15% ...
Spivonious's user avatar
0 votes
1 answer
447 views

The service broker is administratively disabled

I have just restored some databases what use service broker from LIVE to staging. it is not working and when I put a profile trace to run it only shows messages related to database id 1 and 4, ...
Marcello Miorelli's user avatar
2 votes
1 answer
9k views

Activity Monitor paused

Some of our end-users still like to use the Activity Monitor in SQL Server. When setting up our SQL-server 2016 servers the activity monitor always ends up in a paused state when the users are not ...
chittybang's user avatar
0 votes
2 answers
2k views

PostgreSQL slow query log entries contain no query details, only duration

I have a PostgreSQL RDS instance hosted in AWS. I have set the log_min_duration_statement setting to 1 second. When checking my log for slow queries I found the following six entries which don't ...
blizz's user avatar
  • 157
10 votes
4 answers
20k views

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 ...
Bartosz X's user avatar
  • 503
-1 votes
1 answer
55 views

Can a query that executes quickly still be a poorly written query? [closed]

This is more of a theoretical question and here is some background. Our system uses MySQL and was experiencing some slowdowns late in the day. Running SHOW FULL PROCESSLIST showed me around 10 rows ...
kenshin9's user avatar
  • 119
2 votes
1 answer
442 views

Some timeout in query store but get all SP:Starting and SP:Completed in profiler

I have a report SP running. The user complaint report timeout sometimes. And I do get some canceled execution plan in my query store. But in my profiler tracing file, every SP:Starting has its SP:...
DBALUKE HUANG's user avatar
12 votes
2 answers
808 views

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 ...
jrdevdba's user avatar
  • 288
3 votes
1 answer
425 views

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 ...
SE1986's user avatar
  • 2,000
3 votes
2 answers
934 views

Max worker thread exceeded after manual AG failover

We have two SQL Server 2016 SP2 CU6 Enterprise running on physical hardware (32 cores) with one AG that contains 5 db's. The secondary is not readable. Today we did a planned manual failover, so we ...
Frederik Vanderhaegen's user avatar
1 vote
1 answer
77 views

MySQL Server :: My C Code can remotely create a database, but not "INSERT INTO" it

I’ve written a C program which does the following when it starts: Connects to a remote Linux MySQL server over the network Creates a new, uniquely-named database Sends a “USE _____” command to ...
Pete's user avatar
  • 111
2 votes
1 answer
3k views

Replicaton - The current transaction cannot be committed and cannot be rolled back to a savepoint

After creating a replication publication, I go ahead and create a subscription using the script below: -----------------BEGIN: Script to be run at Publisher 'MY_PUBLISHER_SERVER'-------------- use [...
Marcello Miorelli's user avatar
2 votes
2 answers
305 views

is it possible to trim the table output for a specific job?

I have a routine to save the logins and apply them on a different server , and I run this routine from a job that I have scheduled to run everyday. On that job I have specified these 3 things: Log ...
Marcello Miorelli's user avatar
1 vote
0 answers
2k views

service broker - poison message - how to handle? how to enable poison messase handling?

I am getting constantly this error message on service broker: POISON MSSAGE - Message Removed from the queue to allow other messages to proceed - ApplicationID: 377411 select top 1000 * from ...
Marcello Miorelli's user avatar
6 votes
1 answer
1k views

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.....
SE1986's user avatar
  • 2,000
0 votes
1 answer
3k views

length of the result exceeds the > length limit (2GB) of the target large type

Getting the following error message on the Sql Server Error Log: SQLServer Error: 599, WRITE: The length of the result exceeds the length limit (2GB) of the target large type. [SQLSTATE 42000] (...
Marcello Miorelli's user avatar
1 vote
2 answers
7k views

Imposssible to expand a database in SQL Server Management Studio

I am experiecing a strange problem. I have a SQL Server 20008 R2 instance that recently (after years of running smoothly) started to become slow. One symptom that I notice is that when working from ...
user193655's user avatar
2 votes
1 answer
879 views

How can I trace the root cause of a MySQL database table that crashed?

Are there any standard practices or methods for tracing the cause of a MySQL table crash? If I repair a table that had crashed, how do I determine what caused it to crash in the first place? Storage ...
UncaughtTypeError's user avatar
1 vote
1 answer
990 views

Why my transaction has not been replicated? What was the transaction sequence number?

I have been troubleshooting a replication problem, according to the picture below: with reference to the picture above, the bit that says Sessions of the distribution agent I can get using the ...
Marcello Miorelli's user avatar
1 vote
1 answer
2k views

How to run SQL Profiler to monitor 1 specific stored procedure? [duplicate]

I have an issue where a stored procedure will run properly when executed from SQL Management Studio, but when the stored procedure is called from an application, it doesn't return the results to the ...
D_L's user avatar
  • 11
3 votes
2 answers
3k views

SQL SERVER FileTable/FILESTREAM share suddenly becomes unavailable

We had difficulty setting up a FileTable share on a SQL 2014 instance and after giving up on trying to name it after our instance name, we left the name of the share as mssqlserver, but it finally ...
Eric Swiggum's user avatar
3 votes
4 answers
392 views

SQL Server unusual behavior on LOB insertion

We are facing unusual behavior on a SQL Server 2008 R2 instance. We have a small .NET application, which we use to insert images and pdf files inside database as VARBINARY. Sometimes, we are facing ...
Aasim Abdullah's user avatar
0 votes
1 answer
2k views

Periodically very slow execution of simplest queries

Inspecting MySQL slow query log I found out that in certain periods of time there are a bunch of queries in log which are supposed to be very fast but were actually very slow. For example: # User@...
Pustovalov Dmitry's user avatar
6 votes
4 answers
14k views

"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 ...
SQL_Deadwood's user avatar
1 vote
4 answers
5k views

Rows deleted in the subscriber - what to do? - SQL Server Transactional Replication

Someone has delete by mistake a row of a table in the subscribed server/database. I am getting the following error message: The row was not found at the Subscriber when applying the replicated (...
Marcello Miorelli's user avatar
2 votes
1 answer
1k views

SQL Server uses too much CPU

I have a VM 2012 R2 server with SQL Server 2014 Express SP2 installed. There are some applications and databases, but nothing too big. Databases are small, about 100MB size combined. At some moment (...
yaapelsinko's user avatar
0 votes
1 answer
498 views

Visual Studio 2010 Shell Error - is it Causing this SQL Server error?

Visual Studio 2010 Isolated Shell has the infamous "Invalid License Data. Reinstall" error. I have SSMS 2014. I have tried reinstalling several times, I installed Visual Studio 2013 but SSMS doesn't ...
justwondering's user avatar
2 votes
0 answers
133 views

Why is my server with memory pressure when I have 4.3GB available memory? [duplicate]

I'm doing a couple of tests in my local computer and I noticed that the plan cache was being wiped every couple of minutes. After researching a bit I noticed on my error log that my instance was with ...
Tiago's user avatar
  • 279
11 votes
6 answers
96k views

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-...
TallGuy's user avatar
  • 371
1 vote
0 answers
2k views

How to identify file for "The system cannot find the file specified." during a pg_ctl -D start?

I'm getting one message during pg_ctl -D start of the standby server. Perhaps more of a general troubleshooting question. This is what I'm seeing when I do a pg_ctl -D start: D:\>pg_ctl -D d:\...
Jay Cummins's user avatar
13 votes
4 answers
54k views

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 ...
RayofCommand's user avatar
  • 1,373
6 votes
1 answer
3k views

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 ...
Md Haidar Ali Khan's user avatar
19 votes
4 answers
86k views

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....
Marcello Miorelli's user avatar
2 votes
1 answer
384 views

SQLServerAgent Error: 32

A job that "will Recycle SQL Server Agent Error Logs once every week on Sunday at 12:00:00 AM." has been failing this weekend on SQL Server 2008 R2 SP2 Enterprise. This job executes a system stored ...
Razvan Zoitanu's user avatar
2 votes
1 answer
2k views

Cleaning up orphaned metadata in information_schema

OK - so the server (Percona 5.6 in this case) 'went away' in the middle of declaring a constraint like so: alter table mytable add constraint fk_mytable_myothertable foreign key (myothertable_id) ...
Eljuan's user avatar
  • 182