Viewing 15 posts - 2,371 through 2,385 (of 19,560 total)
EL Jerry (8/5/2014)
Revenant (8/5/2014)
YellowPages
Eight
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 5, 2014 at 7:51 pm
Markus (8/5/2014)
I am now having the storage team look into the IO and back end storage. There has to be an issue somewhere in one of the layers.
I'd agree...
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 5, 2014 at 11:06 am
For patches, I like to request enough time to run a full backup as well as enough time to be able to rollback in the event of failure.
And then pad...
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 5, 2014 at 11:00 am
Yes, that article would be 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 5, 2014 at 10:30 am
sqldriver (8/5/2014)
SQLRNNR (8/5/2014)
What are your resource governor configurations?What is the Max memory configured for SQL Server?
What is the memory reservation assigned to the VM?
Resource governor is not configured.
Max 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
August 5, 2014 at 9:41 am
What are your resource governor configurations?
What is the Max memory configured for SQL Server?
What is the memory reservation assigned to the VM?
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 5, 2014 at 9:14 am
That kind of question would be best posed to Microsoft Learning.
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 5, 2014 at 7:58 am
Redirect Posts to the following thread please.
http://www.sqlservercentral.com/Forums/Topic1599706-2799-1.aspx
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 5, 2014 at 7:57 am
What are your baseline runtimes performance analysis of checkdb vs the runtimes after these config changes?
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 5, 2014 at 7:56 am
Koen Verbeeck (8/5/2014)
SQLRNNR (8/5/2014)
Koen Verbeeck (8/5/2014)
SQLRNNR (8/5/2014)
pmadhavapeddi22 (8/5/2014)
I am surprised to know that such a simple QOTD "FROM Hugo" !!! :w00t:Agreed. Hugo usually gives something much more involved.
It's 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 5, 2014 at 7:53 am
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
August 5, 2014 at 7:50 am
Truncate is a table wide operation. If you have your table partitioned, truncating will truncate all partitions.
If you want to delete the data in a single partition, the quickest...
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 5, 2014 at 7:44 am
MadAdmin (8/5/2014)
but,
what I did was select the proc stats from dm_exec_procedure_stats and order by total logical reads...
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 5, 2014 at 7:38 am
Koen Verbeeck (8/5/2014)
SQLRNNR (8/5/2014)
pmadhavapeddi22 (8/5/2014)
I am surprised to know that such a simple QOTD "FROM Hugo" !!! :w00t:Agreed. Hugo usually gives something much more involved.
It's the holiday season for...
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 5, 2014 at 7:35 am
pmadhavapeddi22 (8/5/2014)
I am surprised to know that such a simple QOTD "FROM Hugo" !!! :w00t:
Agreed. Hugo usually gives something much more involved.
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 5, 2014 at 7:13 am
Viewing 15 posts - 2,371 through 2,385 (of 19,560 total)