Viewing 15 posts - 121 through 135 (of 22,224 total)
There can be no other connections to the database when you run a restore. That includes SSMS. So, if you have that database open in front of you and you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 13, 2025 at 2:26 pm
In the real world, one has to hope for the best, plan for the worst and insure for anything else! 😎 Weather is just one of the many factors,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 13, 2025 at 1:41 pm
Most of us know Murphy's law that 'anything that can go wrong will go wrong', but fewer of us realise that Murphy was an optimist.
...
Good gosh. That's incredible. Well...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 13, 2025 at 1:40 pm
You've described the scenario, but I don't see much in the way of solutions. Do you have a question? If not, expand this out, provide some solutions, and submit it...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 9, 2025 at 1:28 pm
Not a clue. I haven't seen something like this before. However, I'd suggest not bothering to look at the proc cache any more. Look elsewhere. What the heck is using...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 9, 2025 at 1:25 pm
There's a login event that will let you know when a login has been completed. You can also look for login errors. Here's an article on the concept. Here's...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 9, 2025 at 1:20 pm
You could try forcing the processing over to the remote server through OPENQUERY so that filtering is done there. Otherwise, the way your code is written, yep, it's moving everything...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 7, 2025 at 1:45 pm
Do you have monitoring in place to understand why the CPU is maxing out? Without more data, I'd just be guessing.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 7, 2025 at 1:42 pm
Strictly talking INSERT, and nothing else. Assuming the data being inserted is coming from an identical structure. That structure does, in fact, have foreign keys in place. Those keys are...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 3, 2025 at 1:53 pm
Pretty sure the answer to using the Microsoft backups is that your choices are:
The issue is simple, that stuff is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 19, 2024 at 2:45 pm
OMG. I'm so sorry. Deleting my responses. Reading is fundamental and I have failed.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 18, 2024 at 4:26 pm
You can use Extended Events to capture the statements executed. If I was doing this one, I would capture rpc_staring, sp_statement_completed and rpc_completed. All three filtered to the object id...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 18, 2024 at 4:15 pm
Just my 2ct: did you try to checkpoint all databases before running the backup ?
btw: We mostly produce local backup files and only copy those afterward to a safe...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 18, 2024 at 4:13 pm
<deleted>
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 18, 2024 at 3:35 pm
Well, doesn't sound ideal then. Still, might be worth a test.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 17, 2024 at 8:10 pm
Viewing 15 posts - 121 through 135 (of 22,224 total)