Viewing 15 posts - 7,606 through 7,620 (of 49,552 total)
Eirikur Eiriksson (10/4/2014)
Is it just me or does this smell like a spam? A quick search returned few similar postings referencing the same vendor on other sites.😎
It's the same kind...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2014 at 6:02 am
I mean your checks to see if it was safe to delete the log file were inadequate...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2014 at 5:58 am
Maybe it wasn't actually repaired, just deallocated by something like an index rebuild.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 4, 2014 at 3:59 am
SQL logs an entry in suspect pages when it finds a corrupt page. In your case, that happened on the 11th of last month and SQL only found an error...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 3, 2014 at 3:16 pm
Great, so post them please. Pictures of SSMS's graphical rendition of the deadlock graph files is useless as it's only part of the information. Hence why I asked for the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 3, 2014 at 3:15 pm
No, it cannot, as the error message says.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 3, 2014 at 11:15 am
If you need to sum the entire Transactions table 300 times a second (with no filtering or grouping), I'd say you need to either reconsider your design or your requirements....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 3, 2014 at 10:58 am
That's very likely going to be the source of those waits then. SQL's probably calling out to the OS to do the encryption and decryption of the messages.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 3, 2014 at 9:13 am
aykut canturk (10/3/2014)
my logic says less lock is better.
It's no where near that simple.
Is using the hint going to damage the database? Of course not.
That doesn't mean you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 3, 2014 at 9:11 am
Running service broker?
Using any encryption anywhere?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 3, 2014 at 8:09 am
But in that case, what's the point of the hint?
You said that data is not getting updated, so why would you need a hint that lets you read through exclusive...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 3, 2014 at 7:34 am
kevaburg (10/3/2014)
The table sys.dm_exec_sql_text only stores currently executing SQL and once the execution is completed will be removed.
Currently cached, not currently executing, but otherwise, yeah. An insert ... values is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 3, 2014 at 7:16 am
Please note: 4 year old thread. Please post new questions in a new thread. Thank you.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 3, 2014 at 7:10 am
aykut canturk (10/3/2014)
but my my question is "is there anything wrong to use WITH (NOLOCK) for reading non-changing fields"
Yes.
as I don't need exact results and I'm okay with dirty...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 3, 2014 at 6:50 am
A select alone cannot deadlock. There's likely more to that transaction and there's definitely another process involved.
If you can get hold of the deadlock graph, it'll be possible to fix...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 3, 2014 at 5:37 am
Viewing 15 posts - 7,606 through 7,620 (of 49,552 total)