Viewing 15 posts - 2,176 through 2,190 (of 19,560 total)
Can you provide table structures and sample data that will illustrate the issue?
This will help people see the issue and better be equipped to help 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 19, 2014 at 11:49 am
Ed Wagner (8/19/2014)
djj (8/19/2014)
Ed Wagner (8/19/2014)
SQLRNNR (8/19/2014)
lemonadeSummer
Winter
Driving
Daisies
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 19, 2014 at 11:39 am
Depends on what you wish to monitor.
Solarwinds Ignite is top dog for monitoring waits and associating queries to which waits.
SQL Sentry is very good, but has a bit 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
August 19, 2014 at 11:19 am
Luis Cazares (8/19/2014)
Lynn Pettis (8/19/2014)
Granted, it 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 19, 2014 at 11:15 am
Lynn Pettis (8/19/2014)
Granted, it is a non-profit...
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 19, 2014 at 11:12 am
smtzac (8/19/2014)
Can you please help me to understand this scenario:
Log file size right now 100 GB
Big translation took place, size of 125 GB.
would the Log file size be...
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 19, 2014 at 9:44 am
lemonade
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 19, 2014 at 9:16 am
N_Muller (8/19/2014)
curious_sqldba (8/19/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 19, 2014 at 9:09 am
GilaMonster (8/19/2014)
TheSQLGuru (8/18/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 19, 2014 at 9:07 am
GilaMonster (8/19/2014)
MyDoggieJessie (8/18/2014)
TheSQLGuru (8/18/2014)Don't forget the other part of the equation - Cost Threshold for Parallelism. The default of 5 is universally too low.
What's a good way...
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 19, 2014 at 8:52 am
Yes to the Reporting Services Configuration manager.
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 18, 2014 at 3:12 pm
higgim (8/18/2014)
Not a happy chap with some of the help being offered! Go figure 🙂Qira (8/18/2014)
Dear Mr Higgam,You're helping me sir. Thanks to you. But no thanks to other one.
http://www.sqlservercentral.com/Forums/Topic1604205-392-2.aspx
Very...
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 18, 2014 at 2:56 pm
True. Sharepoint should be set to maxdop of 1. AX and other flavors of Dynamix also work better with maxdop 1.
That said, it is best to know your...
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 18, 2014 at 2:43 pm
I currently run SSRS2012 on Win7 Home. One of things I found I had to do was set the url to use port 8080.
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 18, 2014 at 2:03 pm
Ed Wagner (8/18/2014)
djj (8/18/2014)
Ed Wagner (8/18/2014)
crookj (8/18/2014)
SQLRNNR (8/18/2014)
bolognasalami
Italy
Boot
Strap
Bill
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 18, 2014 at 12:51 pm
Viewing 15 posts - 2,176 through 2,190 (of 19,560 total)