Viewing 15 posts - 1,981 through 1,995 (of 19,560 total)
djj (9/30/2014)
SQLRNNR (9/29/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
September 30, 2014 at 7:33 am
You're 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
September 30, 2014 at 7:26 am
Eirikur Eiriksson (9/29/2014)
djj (9/29/2014)
I tell them they should only store a standardized value. A prime...
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
September 29, 2014 at 11:10 pm
Koen Verbeeck (9/29/2014)
Hire an overpriced consultant. Chances are they'll listen to him/her...
Erm, chances are often just about as good as them listening to an FTE.:-D
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
September 29, 2014 at 11:01 pm
http://il-adan.blogspot.com/2013/07/hyper-v-clone-machine-with-sql-server.html
Here is an example on how to do it.
And a recommendation from VMWare on their best practice recommendation
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
September 29, 2014 at 10:59 pm
Lynn Pettis (9/29/2014)
Any help here would be appreciated. I am going to go get sleep as I have been up all night (work nights here in Afghanistan).
Ha, I saw...
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
September 29, 2014 at 10:49 pm
It is best to quiesce the databases before cloning the machine. You can achieve that through stopping the SQL services.
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
September 29, 2014 at 10:46 pm
Not an XSL, but it is better than that.
Here is a deadlock shredder by Wayne Sheffield.
http://blog.waynesheffield.com/wayne/code-library/deadlocks/shred-deadlock-graph/
You can take the xml from the graph that is produced by XE and just...
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
September 29, 2014 at 10:45 pm
You are getting a cross contamination from the index stats for other databases. SYS.DM_DB_INDEX_USAGE_STATS contains entries for every database and sometimes index_id and object_id might be the same in...
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
September 29, 2014 at 8:13 pm
sludge
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
September 29, 2014 at 5:18 pm
Koen Verbeeck (9/29/2014)
SQLRNNR (9/26/2014)
Koen Verbeeck (9/26/2014)
Apparently PASS passwords (sorry for the alliteration) were compromised[/url].Change your passwords if you haven't already...
ARRRGGGGHHH
Hopefully you didn't change them right away, because there was no...
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
September 29, 2014 at 7:57 am
andrew.ing (9/29/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
September 29, 2014 at 7:53 am
SQL-DBA-01 (9/29/2014)
SSCrazy,I dont think what yopu'd suggested would work...as unless the first job is completed, I do not want to start the second job.
Yup this will work. I...
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
September 29, 2014 at 7:48 am
Koen Verbeeck (9/26/2014)
Apparently PASS passwords (sorry for the alliteration) were compromised[/url].Change your passwords if you haven't already...
ARRRGGGGHHH
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
September 26, 2014 at 9:10 am
GilaMonster (9/26/2014)
Could anyone with a moment please check my answer here: http://www.sqlservercentral.com/Forums/Topic1618884-391-1.aspxWant to make sure there's no small inaccuracy which could get exploited.
Looks good.
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
September 26, 2014 at 8:54 am
Viewing 15 posts - 1,981 through 1,995 (of 19,560 total)