Viewing 15 posts - 15,121 through 15,135 (of 19,560 total)
I found the following suggestions.
1. Make sure that you are not using an unsupported tuning option. The following link provides the unsupported tuning options: http://msdn.microsoft.com/en-us/library/ms345360.aspx
2. Ensure that the two SQL...
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 7, 2010 at 4:46 pm
Is the agent running on a different service account? I'm thinking there may be a permissions issue.
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 7, 2010 at 4:39 pm
In case you can't get to Glenn's blog link (I couldn't launch it), here is an alternative script that I use. It is not a SQL2K5 script but still...
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 7, 2010 at 4:33 pm
When you stored the package in the MSDB store on the server, what security settings did you select?
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 7, 2010 at 4:25 pm
Gift Peddie (4/7/2010)
GSquared (4/7/2010)
Gift Peddie (4/7/2010)
Lynn Pettis (4/7/2010)
Gibraltar strikes again. She really needs to learn some tact.
Lynn,
When I say a product comes with limitations I know the current internals...
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 7, 2010 at 4:23 pm
ksparke (4/7/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 7, 2010 at 4:20 pm
Jeff Moden (4/7/2010)
Gianluca Sartori (4/7/2010)
CirquedeSQLeil (4/6/2010)
Jeff Moden (4/6/2010)
Steve Jones - Editor (4/6/2010)
It seemed to perform 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 7, 2010 at 4:07 pm
You're welcome
I find that result quite interesting. I am glad you found the solution.
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 7, 2010 at 4:04 pm
RBarryYoung (4/7/2010)
Here we go...
Oh bother.
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 7, 2010 at 4:01 pm
Alvin Ramard (4/7/2010)
GSquared (4/7/2010)
Alvin Ramard (4/7/2010)
Lynn, instead of him (her?), try she-he-it? 😛I always prefered "(s)he/it". Works better when you pronounce it all as one word.
That's what...
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 7, 2010 at 4:01 pm
GSquared (4/7/2010)
Grant Fritchey (4/7/2010)
No celebrations for me until we hit 20,000.When The Thread has more posts than Steve, does that mean it gets to be the editor for the site?
I...
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 7, 2010 at 3:59 pm
This is something that can happen on busy networks from time to time. It could be related to packet loss and the client thinking the server is not present,...
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 7, 2010 at 2:31 pm
Pranav Shah-410191 (4/7/2010)
There is also BOL.
There are also tons of web-sites, books, etc.
But then there is something more valuable EXPERIENCE.
So, I thank you all for sharing your experience...
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 7, 2010 at 2:26 pm
Jack Corbett (4/7/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 7, 2010 at 2:23 pm
Lynn Pettis (4/7/2010)
CirquedeSQLeil (4/7/2010)
Gibraltar no like Lynn. Taking her toys and going to play in another sandbox. 😀
Some times the Saints just have to knock a few heads. ...
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 7, 2010 at 2:08 pm
Viewing 15 posts - 15,121 through 15,135 (of 19,560 total)