Viewing 15 posts - 8,146 through 8,160 (of 22,219 total)
The only way to get a really accurate count would be to use extended events or trace. Since you're 2008 trace will be easier since there is no GUI for...
"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
May 14, 2014 at 10:48 am
That's a client testing issue. You're not going to see any problems from it during your upgrade in SQL Server, side-by-side or in-place. But you could see issues on the...
"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
May 14, 2014 at 8:51 am
It's absolutely using sys.dm_os_waits_stats. But if you want to know which query, just run extended events/trace to capture 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
May 14, 2014 at 8:07 am
SQLRNNR (5/14/2014)
Grant Fritchey (5/14/2014)
Ed Wagner (5/14/2014)
Koen Verbeeck (5/14/2014)
GilaMonster (5/14/2014)
Koen Verbeeck (5/14/2014)
This was a funny topic 😀 (especially the last replies)Sorry, am a little short on patience today.
I pretty much laughed...
"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
May 14, 2014 at 8:01 am
Again, if you do a search on the internet, there are tons of articles on this. Not just one. Here's a blog entry from MS on troubleshooting the issue. This...
"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
May 14, 2014 at 8:00 am
Greg Edwards-268690 (5/14/2014)
Grant Fritchey (5/14/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
May 14, 2014 at 6:26 am
I'd say show them that error message and let them look it up through Bingle. It's absolutely a hardware related problem and it's very well documented as such out on...
"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
May 14, 2014 at 6:20 am
Check the documentation on the BACKUP command. There is no facility for just getting the READ_ONLY file groups. You'll have to go after each one individually. Partial backup documentation says...
"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
May 14, 2014 at 6:13 am
Blocking caused by another process doing an INSERT/UPDATE/DELETE which will stop the scan.
"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
May 14, 2014 at 6:08 am
It's absolutely an I/O issue. I'd say your disks are being overwhelmed because the issue isn't that a given process is waiting for disk access while another process uses, but...
"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
May 14, 2014 at 6:07 am
Ed Wagner (5/14/2014)
Koen Verbeeck (5/14/2014)
GilaMonster (5/14/2014)
Koen Verbeeck (5/14/2014)
This was a funny topic 😀 (especially the last replies)Sorry, am a little short on patience today.
I pretty much laughed with the "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
May 14, 2014 at 6:04 am
Since you now know that you need to replace the one character, you could try using the REPLACE T-SQL statement on the string (not on the column) to replace the...
"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
May 14, 2014 at 6:03 am
yuvipoy (5/14/2014)
for the test of 1000 record on a table with...
"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
May 14, 2014 at 5:49 am
Well done. That's great to hear.
"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
May 13, 2014 at 5:21 pm
Sorry, it took me a little while to write that up and in the mean time others have posted roughly the same stuff. I kept getting distracted. Doggone twitter.
"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
May 13, 2014 at 4:38 pm
Viewing 15 posts - 8,146 through 8,160 (of 22,219 total)