Viewing 15 posts - 3,196 through 3,210 (of 19,564 total)
Toreador (4/16/2014)
SQLRNNR (4/15/2014)
Every system has a sys.databases and that is what the question was referring to.
No it isn't - the question clearly refers to [dbo].[databases]
I know the script said [dbo].[databases]....
April 16, 2014 at 6:28 am
mlwiller2 (4/15/2014)
4. On restart, enable (and check) AWE setting max system memory to?
16 is where i would start
April 15, 2014 at 4:01 pm
Dineshbabu (4/15/2014)
Its good try. But I will not agree with your answer.
I will go for Query used to check the data is not correct.
Because there can be cases...
April 15, 2014 at 1:11 pm
whether from profiler or from XE, interpreting a deadlock graph seemed to be the question. That link should help in interpreting a deadlock graph.
Here is a link about...
April 15, 2014 at 11:32 am
Good you have the latest sp.
The qp may have been offline for those errors because the service was trying to transition from one node to another. The reason it...
April 15, 2014 at 8:13 am
what is returned by @@version?
April 14, 2014 at 8:46 pm
Perry Whittle (4/14/2014)
mlwiller2 (4/14/2014)
But yeah its x86. Both SQL (standard) and windows server 2003 (standard) are 32bit versions.
Unfortunately, with Windows 2003 Standard 32 bit the OS will not support more...
April 14, 2014 at 5:12 pm
GilaMonster (4/14/2014)
SQLRNNR (4/14/2014)
GilaMonster (4/14/2014)
Hmmm... http://www.sqlservercentral.com/Forums/Topic1561455-146-1.aspxYeah looks like it was removed.
No, I linked it wrong.
If you're going to be around a bit, could you watch that one and this one please?
http://www.sqlservercentral.com/Forums/Topic1561627-1550-1.aspx
Yup...
April 14, 2014 at 5:07 pm
GilaMonster (4/14/2014)
Hmmm... http://www.sqlservercentral.com/Forums/Topic1561455-146-1.aspx
Yeah looks like it was removed.
April 14, 2014 at 4:53 pm
Stewart "Arturius" Campbell (4/14/2014)
almost tripped up, but remembered that databases is a system view, in the sys schema, not dbo.
The only way to reflect it in the...
April 14, 2014 at 11:54 am
See if this tutorial is of any help in understanding the deadlock graph.
The image you pasted is not easy to read.
http://sqlmag.com/database-performance-tuning/gathering-deadlock-information-deadlock-graph
April 13, 2014 at 9:23 pm
Gary Varga (4/11/2014)
April 11, 2014 at 11:40 am
Viewing 15 posts - 3,196 through 3,210 (of 19,564 total)