Viewing 15 posts - 15,541 through 15,555 (of 19,560 total)
You're welcome.
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 1, 2010 at 3:19 pm
Is this a default instance or a named instance?
It also looks like you are still using port 1533 - thus it is still a static port configuration.
Here is an article...
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 1, 2010 at 3:18 pm
I have used them in the past for different exams. Each time, the transcender was more difficult than the actual exam.
I imagine the same would hold true here.
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 1, 2010 at 3:16 pm
If standard is already installed, then you would have 49 instances remaining for enterprise edition.
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 1, 2010 at 3:11 pm
Chad Crawford (3/30/2010)
Dear Friend Master SQL Guru, 😀
Ha, I just barely noticed that.
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 1, 2010 at 2:54 pm
WayneS (4/1/2010)
CirquedeSQLeil (4/1/2010)
Congrats on finding the issue.This would be a nice example of a bad loop.
Bad loop indeed. Hmm, what would be a good loop? :w00t:
A hoola hoop.
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 1, 2010 at 2:46 pm
WayneS (4/1/2010)
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 1, 2010 at 2:44 pm
Check out this blog on the topic.
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 1, 2010 at 2:29 pm
Agreed on the enmity. The media is giving them so much pub right now, I think they enjoy 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 1, 2010 at 2:19 pm
Chad Crawford (4/1/2010)
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 1, 2010 at 2:15 pm
The original that Chad is referencing can be found here[/url].
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 1, 2010 at 2:13 pm
nelsonj-902869 (4/1/2010)
Besides the side by side install, have you considered moving all of the databases to SQL 2005?
Eventually, we will convert the remaining databases, but several are...
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 1, 2010 at 2:09 pm
WayneS (4/1/2010)
Michael Meierruth (4/1/2010)
So what was the purpose of this discussion on 'table scan vs clustered index scan'.
That discussion evolved from a comment being made about someone not thinking that...
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 1, 2010 at 2:06 pm
Chad Crawford (4/1/2010)
CirquedeSQLeil (4/1/2010)
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 1, 2010 at 2:04 pm
Abhijit More (4/1/2010)
After doing some research I found this is becuase of max connection limit for the SQL node. and the siginificant part of sql memory has been ...
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 1, 2010 at 2:02 pm
Viewing 15 posts - 15,541 through 15,555 (of 19,560 total)