Viewing 15 posts - 5,836 through 5,850 (of 6,676 total)
For anybody who is interested, setting MAXDOP to 1 allowed the process to complete successfully, even with ONLINE=ON.
So, it definitely looks like an issue with parallelism on this index. ...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 15, 2008 at 1:48 pm
GilaMonster (12/15/2008)
By unrecoverable, do you mean the deadlock detector's not picking it up? Does having traceflag 1222 on result in a deadlock graph in the error log?
By unrecoverable, I mean...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 15, 2008 at 1:43 pm
Thanks - that is what I was afraid of. I guess we are going to open a ticket with Microsoft.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 15, 2008 at 1:37 pm
Well, I guess the answer is: It depends :hehe:
Do you want to slow down your inserts/deletes? If so, then yeah - you probably want to add some indexes. ...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 14, 2008 at 10:21 pm
No, you are not going to be able to do that. What you will need to do is build the cluster, install SQL Server on the cluster and then...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 12, 2008 at 4:25 pm
Everything looks right - don't see anything that jumps out and says there might be a problem with the cluster setup.
Sorry, I can't think of anything else to look at.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 12, 2008 at 3:48 pm
You can use sp_notify_operator:
sp_notify_operator
[ @profile_name = ] 'profilename' ,
[ @id = ] id ,
[ @name = ] 'name'...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 12, 2008 at 2:06 pm
Okay - that makes sense. I did not see the other replies before I sent mine. I agree with Steve, you really should be looking at setting up...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 12, 2008 at 1:07 pm
Why are you remoting into the server to run these queries? You should use SSMS on your local workstation instead.
I would be very concerned about moving temp files used...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 12, 2008 at 12:53 pm
The semi-colon is a statement terminator, so you wouldn't put it at the end of every line. Only at the end of each statement - and only before the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 12, 2008 at 12:29 pm
Garadin (12/12/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 12, 2008 at 12:16 pm
Christopher Stobbs (12/11/2008)
but I must say sorry I don't know how the hanging ) stayed as it did.
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 12, 2008 at 12:12 pm
Well, to be perfectly honest I am now at a complete loss. You really should be able to see that database being started by SQL Server. It really...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 12, 2008 at 11:37 am
Hey Jeff - you realize that the OP posted this yesterday (as Urgent) and has not replied back at all? Wonder how urgent it really was 😉
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 11, 2008 at 8:06 pm
Sam Aaron Navaraj (12/11/2008)
My problem is similar but with differential backups on the LiteSpeed 2005 [Version 4.6.0.00303]
" [SQLSTATE 01000] (Message 1) SQL Server has returned a failure message...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 11, 2008 at 5:55 pm
Viewing 15 posts - 5,836 through 5,850 (of 6,676 total)