Viewing 15 posts - 16,786 through 16,800 (of 19,560 total)
RBarryYoung (3/6/2010)
GilaMonster (3/6/2010)
RBarryYoung (3/6/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
March 6, 2010 at 11:02 pm
iamthemanx (3/6/2010)
Maybe I’ll tackle an Oracle 11g certification in the fall. Good luck to all those preparing for certification…
That would be awesome for you!!!! Showing you're proficient on both...
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
March 6, 2010 at 11:01 pm
My wife and I recently had this same conversation. If I were the Boss, would I allow somebody to work for me while impaired. The answer was no....
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
March 6, 2010 at 1:26 pm
waffle
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
March 6, 2010 at 8:47 am
Paraffin
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
March 6, 2010 at 8:47 am
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
March 6, 2010 at 8:44 am
Once again, very interesting. Checking this last one out, and it seems very similar in speed to the other "fastest" ones submitted. Good job on coming up with...
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
March 6, 2010 at 8:42 am
cRuchika (3/4/2010)
and we avoid using AGGREGATE and SORT transformation....
I would be careful on the sort transformation. Many times a sort transformation is necessary when using a merge join...
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
March 6, 2010 at 8:40 am
Sure somebody here could help, if you post the actual query or 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
March 6, 2010 at 8:33 am
This article might be useful for you.
http://www.mssqltips.com/tip.asp?tip=1571
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
March 6, 2010 at 8:23 am
Some reading first:
http://msdn.microsoft.com/en-us/library/cc966412.aspx
Some perfmon stats to look at
Average Disk Seconds/Read
Average Disk Seconds/write
Each of those should be under 10ms for good, between 10-20ms is average,and over 50ms is bad.
Another perfmon stat
Avg....
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
March 6, 2010 at 1:32 am
wow
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
March 6, 2010 at 1:26 am
For one that has already been dropped, you will not be able to determine that unless you had auditing enabled or a DDL trigger that logs such actions.
Recommendation: Create...
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
March 6, 2010 at 1:24 am
You can run a profiler trace to try and capture the code. Since it happens every 5 minutes, you need only run the trace for a short time frame...
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
March 6, 2010 at 1:20 am
I would check the freelancing sites and tech recruiters for your area, in that order.
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
March 6, 2010 at 1:12 am
Viewing 15 posts - 16,786 through 16,800 (of 19,560 total)