Viewing 15 posts - 5,386 through 5,400 (of 19,560 total)
Steve Jones - SSC Editor (1/2/2013)
Happy New Year everyone, and welcome back to work.
You didn't need to spoil it like that ;-):-D:hehe:
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 2, 2013 at 9:31 am
edit: double-posted
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 2, 2013 at 2:45 am
For the OP:
Have the coding suggestions helped with the processing time of this report?
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 2, 2013 at 2:44 am
Thanks Steve
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 1, 2013 at 11:14 pm
Evil Kraig F (12/31/2012)
Merry Christmas and Happy New Year to all! Warm wishes for 2013.Oh, yeah, and Happy Birthday to me. :hehe:
HAPPY BIRTHDAY!!
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 31, 2012 at 2:16 pm
Koen Verbeeck (12/30/2012)
Not really sure though why a Microsoft resource is so necessary when the question itself is about a pretty universal...
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 31, 2012 at 12:30 pm
Here's one that is supposed to gather the mount point free space
http://www.powershellneedfulthings.com/?p=36
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 28, 2012 at 8:24 pm
Try deleting the cache file from the project directory.
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 28, 2012 at 1:19 pm
Sounds like some caching. Does it appear the same even after closing BIDS and reopening? Or even clearing the cache file in the project directory?
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 28, 2012 at 1:13 pm
wolfkillj (12/28/2012)
SQLRNNR (12/28/2012)
The Dixie Flatline (12/28/2012)
Santa was certainly good to you, Lynn 🙂I got a lump of coal. :angry:
At least it will keep you warm.;-)
Sadly, the energy content of 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
December 28, 2012 at 12:07 pm
You are 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
December 28, 2012 at 10:57 am
I have two things. XE and PoSH.
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 28, 2012 at 10:50 am
The SAN numbers are reporting just the time in the SAN. The numbers from SQL Server report the time it left SQL Server until it gets back to 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
December 28, 2012 at 10:49 am
I think a powershell script would be your best friend for this kind of requirement.
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 28, 2012 at 10:36 am
Thanks for the 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 28, 2012 at 9:54 am
Viewing 15 posts - 5,386 through 5,400 (of 19,560 total)