Viewing 15 posts - 18,841 through 18,855 (of 19,560 total)
GilaMonster (12/9/2009)
CirquedeSQLeil (12/9/2009)
My favorite is the
exec sp_configure 'You come do it for me',1Reconfigure
Potentially a very expensive setting. In terms of money, not server performance. 🙂
Thus, the reason why it could...
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
December 9, 2009 at 10:12 am
There have been a few concerns regarding the moving of data to a different drive if you rebuild an index in a partition scheme.
I want to provide a scenario to...
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
December 9, 2009 at 10:10 am
That's good to know.
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
December 9, 2009 at 9:48 am
Gianluca Sartori (12/9/2009)
GilaMonster (12/9/2009)
exec sp_configure 'Run SQL Faster',1
Wow! Thanks Gail, I'm trying immediately on my production server. :hehe:
Would you also recommend (as a fellow expert) turning on these switches?
exec...
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
December 9, 2009 at 9:46 am
Pleae read the articles provided in the urls posted to this thread.
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
December 9, 2009 at 9:44 am
You're welcome and thanks for the feedback.
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
December 9, 2009 at 8:48 am
GSquared (12/9/2009)
Steve Jones - Editor (12/9/2009)
The switch I use to make mine run faster is the power switch. Turn it on, it flies. turn it off, no so much.
I had...
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
December 9, 2009 at 8:43 am
Oh boy, Gus just went there with the power button on that Lock question.
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
December 9, 2009 at 8:42 am
Steve Jones - Editor (12/9/2009)
I think crystal balls work better than ouji boards. Especially when you drop them on someone's foot to emphasize a point.
Dropping only provides limited emphasis (terminal...
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
December 9, 2009 at 8:40 am
Alvin Ramard (12/9/2009)
Grant Fritchey (12/9/2009)
I always forget this one. How do you flip the "run faster" switch to the on position in SQL Server?
You mean the turbo button on 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
December 9, 2009 at 8:37 am
If you are referring to a server option for sql server to page memory out, you may want to read the below article. This is not necessarily a go...
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
December 9, 2009 at 8:33 am
The answer may have been different at the time of the writing of the question, but as time passed - none of the provided answers are correct at the point...
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
December 8, 2009 at 10:59 pm
Here is an article with additional resources listed in the references section.
http://207.46.16.252/en-us/magazine/2007.03.sqlclusters.aspx
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
December 8, 2009 at 10:34 pm
double post
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
December 8, 2009 at 10:20 pm
If I am understanding your predicament correctly, your SQL server was also a Domain Controller. You have recently demoted that Domain controller to a member server.
Prior to demoting 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
December 8, 2009 at 10:15 pm
Viewing 15 posts - 18,841 through 18,855 (of 19,560 total)