Viewing 15 posts - 8,791 through 8,805 (of 22,219 total)
You need to check all the hardware and configurations. If you've never done that, I strongly recommend getting an expert in the door. Hardware configs, especially I/O, can be extremely...
"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
March 4, 2014 at 8:30 am
Assuming it's getting backed up on a regular basis, I'd just access it's backup to do the restore. You can restore from a file share using "\\myfileshare\myfilename.bak" just fine.
"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
March 4, 2014 at 8:17 am
dbalmf (3/4/2014)
I'm assuming your laptop is part of the same domain as the SQL Server. Create a shared folder on your laptop, You will need to give the user which...
"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
March 4, 2014 at 8:16 am
If it has to be near real time, replication or an availability group (2012 and greater) are your only real options.
By the way, this is a 2014 forum. If people...
"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
March 4, 2014 at 8:15 am
george sibbald (2/28/2014)
thats me out then, xquery gives me a headache. 🙂
Ha! It gives everyone headaches. But you can search out scripts online to pull the information out. It just...
"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
February 28, 2014 at 4:00 pm
george sibbald (2/28/2014)
Grant, is system_health extended...
"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
February 28, 2014 at 3:47 pm
That's a lot of deadlocks. You might actually have impacted performance using the traceflag.
"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
February 28, 2014 at 3:46 pm
dan-572483 (2/28/2014)
"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
February 28, 2014 at 12:35 pm
I'd suggest running DBCC CHECKDB. If that passes, you're OK in terms of corruption. That index may still be fragmented. Actually, pretty sure it will be.
"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
February 28, 2014 at 12:13 pm
There is only limited ability of distributed queries to get and use statistics, so, when it can't get them, it just moves the entire data set over. You can read...
"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
February 28, 2014 at 12:11 pm
I'd keep the app offline yes. Or, you have to deal with killing connections until you can get the database offline, then the app will have X number of errors...
"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
February 28, 2014 at 9:14 am
Yep. That'll work. Or you can export the schema to a T-SQL script and then import that.
"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
February 28, 2014 at 9:12 am
I have seen an issue with it, but only on a system that was getting amazingly huge amounts of deadlocks. For the average system, even the average problematic system, I...
"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
February 28, 2014 at 9:11 am
If it's in Simple Recovery, the only thing you can do to keep the size smaller is reduce the transaction size and count. If you're seeing large logs after maintenance,...
"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
February 28, 2014 at 9:09 am
Koen Verbeeck (2/28/2014)
Grant Fritchey (2/27/2014)
Koen Verbeeck (2/27/2014)
"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
February 28, 2014 at 4:22 am
Viewing 15 posts - 8,791 through 8,805 (of 22,219 total)