Viewing 15 posts - 3,196 through 3,210 (of 19,560 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]....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 15, 2014 at 11:32 am
zit
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 15, 2014 at 8:22 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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 15, 2014 at 8:13 am
balderdash
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2014 at 8:53 pm
what is returned by @@version?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 13, 2014 at 9:23 pm
Not sure if this is just a test post or if you needed help with the data you posted. Could you clarify please?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 11, 2014 at 12:43 pm
Gary Varga (4/11/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 11, 2014 at 11:40 am
Viewing 15 posts - 3,196 through 3,210 (of 19,560 total)