Viewing 15 posts - 18,226 through 18,240 (of 19,560 total)
Lowell (1/11/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
January 11, 2010 at 10:24 pm
WayneS (1/11/2010)
...PS. Jason - just how do you go about embedding the execution plans inside the messages? I've seen you do this many times...
Wayne,
set statistics xml on
Or Click show actual...
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
January 11, 2010 at 9:40 pm
Jeff Moden (1/11/2010)
WayneS (1/11/2010)
Well, the concept comes from Jeff. 'nuf said. 😉
:blush:
Still, that's an interesting warp on the "quirky update". Nicely done, Wayne.
It would be interesting to run a...
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
January 11, 2010 at 9:35 pm
WayneS (1/11/2010)
Probably not random enough, but I changed the 5 initial rows (abc xxxxx, etc.) to be:
1st row: abc 1,
2nd row: zyx 100,
3rd row: def 10000,
4th row: ghi...
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
January 11, 2010 at 9:31 pm
And now, while I was typing up my last post, I see that Wayne has gone and updated the script he provided.
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
January 11, 2010 at 7:13 pm
lmu92 (1/11/2010)
CirquedeSQLeil (1/11/2010)
...
Ok, I now have had some time to go back and redo the tests.
I found one flaw in my tests - they were not equivalent. 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
January 11, 2010 at 7:11 pm
Worth a shot on the service account. Set both to use the same account.
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
January 11, 2010 at 5:06 pm
lmu92 (1/11/2010)
I would use an index on ID, idx on table [test] for it...Running over a minute for 100k rows seems strange...
What test scenario do you use?
I will get back...
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
January 11, 2010 at 4:46 pm
Is the Browser Service running in both instances?
Also, is the server defined using the \InstanceName or using the ,portNum method? Have you tried both methods?
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
January 11, 2010 at 4:45 pm
Are you using named instances by chance?
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
January 11, 2010 at 4:29 pm
lmu92 (1/11/2010)
CirquedeSQLeil (1/11/2010)
I have tested both scripts and compared results.
I would go with the script provided by Wayne. When the result sets are small, then both are similar. ...
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
January 11, 2010 at 4:27 pm
Breaking News...
Is it a move to boost popularity and get the writers on his side, or is it just to come clean?
http://sports.espn.go.com/mlb/news/story?id=4816607
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
January 11, 2010 at 4:20 pm
mohammed moinudheen (1/11/2010)
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
OLE DB provider "SQLNCLI" for linked server...
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
January 11, 2010 at 4:00 pm
lmu92 (1/11/2010)
WayneS (1/11/2010)
Well, the concept comes from Jeff. 'nuf said. 😉
Well, the CrossTab solution I used is based on one of Jeff's articles as well...
Let's see, which one is going...
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
January 11, 2010 at 3:10 pm
lmu92 (1/11/2010)
Based on your sample data it looks like the following would help (as a second step...
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
January 11, 2010 at 3:07 pm
Viewing 15 posts - 18,226 through 18,240 (of 19,560 total)