Viewing 15 posts - 2,296 through 2,310 (of 19,560 total)
Run the script from this link to get the actual sizes and free space in the database.
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
August 11, 2014 at 10:57 pm
Are you getting any errors?
Have you checked for any blocking?
Or is it just that the shrink is running a really long time and never ending?
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
August 11, 2014 at 9:17 pm
Eirikur Eiriksson (8/11/2014)
SQLRNNR (8/11/2014)
Eirikur Eiriksson (8/11/2014)
Check that out - you hit the Rare rank of UDP broadcaster.
With Packets: 1,441, Acks: 4,025, looks like a congestion somewhere:-D
😎
Somebody must have broken 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
August 11, 2014 at 3:12 pm
Can you provide sample data and table structures so we can actually provide a working query for you?
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
August 11, 2014 at 3:11 pm
lsalih (8/11/2014)
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
August 11, 2014 at 2:53 pm
Evil Kraig F (8/11/2014)
SQLTougherGuy (8/11/2014)
Thanks Phil - So what is the standard? Craigs code seemed to work.
I'd recommend going with the new style in 2012+. I haven't had 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
August 11, 2014 at 1:58 pm
Eirikur Eiriksson (8/11/2014)
Check that out - you hit the Rare rank of UDP broadcaster.
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
August 11, 2014 at 1:12 pm
Is your view materialized?
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
August 11, 2014 at 12:27 pm
Thanks. Taking a look.
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
August 11, 2014 at 11:19 am
I'd like to see a link as well please.
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
August 11, 2014 at 11:07 am
I agree with Kraig.
Surely this can't be legitimate can it?
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
August 11, 2014 at 11:03 am
polkadot (8/11/2014)
Are you suggesting that my main problem is 'division by zero'?
At the bottom of my column of percentages I need the average of percentages.
I've tried
=AVG((Fields!To_Your_Store.Value+Fields!Lost_to_Competitors.Value)/Fields!TotalLeads.Value))
and result is...
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
August 11, 2014 at 9:33 am
Try the formulas posted on this link.
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
August 11, 2014 at 8:52 am
tstagliano (8/11/2014)
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
August 11, 2014 at 8:50 am
ronan.healy (8/11/2014)
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
August 11, 2014 at 8:46 am
Viewing 15 posts - 2,296 through 2,310 (of 19,560 total)