Viewing 15 posts - 1,891 through 1,905 (of 19,560 total)
I like to have the safety net. Allow for the log to grow just in case so it doesn't bring down an application.
If the log file does grow, 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
October 17, 2014 at 9:23 am
Rechana Rajan (10/17/2014)
Thanks a lot BrainDonor,Can high CPU usage over 95% for hours will bring SQL Server down??
It depends on what is causing the high cpu. If you have...
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
October 17, 2014 at 9:14 am
Joy Smith San (10/17/2014)
That depends. Are you rebuilding those unwanted indexes? Are you rebuilding all of your indexes? Or are you using a defrag process that 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
October 17, 2014 at 7:54 am
Joy Smith San (10/16/2014)
Grant Fritchey (10/16/2014)
The size of the indexes is much more of a question than the number of them.
Thank you.
So if I have multiple unwanted indexes, obviously...
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
October 16, 2014 at 8:45 pm
Sounds like the cleanup job is not running properly.
You should also check your cdc capture job and make sure it is running without error as well.
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
October 16, 2014 at 7:59 am
Here is a quick article on how to dedupe data.
http://jasonbrimhall.info/2011/03/21/dedupe-data-cte/
Since you know the data is duplicated, then use whatever criteria you know should make the data unique to help identify...
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
October 16, 2014 at 7:29 am
Ed Wagner (10/15/2014)
crookj (10/15/2014)
SQLRNNR (10/15/2014)
bifurcatedforked
Tongue
UVULA
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
October 15, 2014 at 10:00 am
bifurcated
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
October 15, 2014 at 9:33 am
Congrats Grant
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
October 15, 2014 at 9:28 am
Ed Wagner (10/14/2014)
SQLRNNR (10/14/2014)
Ed Wagner (10/14/2014)
crookj (10/14/2014)
SQLRNNR (10/14/2014)
djj (10/14/2014)
Ed Wagner (10/14/2014)
Stuart Davies (10/14/2014)
BWFC (10/14/2014)
Ed Wagner (10/13/2014)
djj (10/13/2014)
Ed Wagner (10/13/2014)
SQLRNNR (10/13/2014)
djj (10/13/2014)
SQLRNNR (10/13/2014)
DanishPastry
creme
Brulee
Fire
Torch
Singer
sewing (machine)
Needle
Thread
Doe
Buck
Rifle
shotgun
Venison
cow heart
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
October 14, 2014 at 10:39 pm
Steve Jones - SSC Editor (10/14/2014)
We implemented ASKIMET for posts. This took effect today and shouldn't slow things down, but we are evaluating and discarding SPAM posts....
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
October 14, 2014 at 2:35 pm
Eirikur Eiriksson (10/14/2014)
Luis Cazares (10/14/2014)
Thank you for the update, Steve.
In an unrelated topic, have you ever seen...
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
October 14, 2014 at 2:33 pm
Ed Wagner (10/14/2014)
crookj (10/14/2014)
SQLRNNR (10/14/2014)
djj (10/14/2014)
Ed Wagner (10/14/2014)
Stuart Davies (10/14/2014)
BWFC (10/14/2014)
Ed Wagner (10/13/2014)
djj (10/13/2014)
Ed Wagner (10/13/2014)
SQLRNNR (10/13/2014)
djj (10/13/2014)
SQLRNNR (10/13/2014)
DanishPastry
creme
Brulee
Fire
Torch
Singer
sewing (machine)
Needle
Thread
Doe
Buck
Rifle
shotgun
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
October 14, 2014 at 10:40 am
Steve Jones - SSC Editor (10/14/2014)
Is quoting and general access slow for anyone else today?
It was painfully slow the past few days but seems a bit better today.
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
October 14, 2014 at 7:31 am
djj (10/14/2014)
Ed Wagner (10/14/2014)
Stuart Davies (10/14/2014)
BWFC (10/14/2014)
Ed Wagner (10/13/2014)
djj (10/13/2014)
Ed Wagner (10/13/2014)
SQLRNNR (10/13/2014)
djj (10/13/2014)
SQLRNNR (10/13/2014)
DanishPastry
creme
Brulee
Fire
Torch
Singer
sewing (machine)
Needle
Thread
Doe
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
October 14, 2014 at 7:30 am
Viewing 15 posts - 1,891 through 1,905 (of 19,560 total)