Viewing 15 posts - 17,701 through 17,715 (of 19,560 total)
Same process you used for the Instance currently installed on the cluster - just a new instance. You need to have resources that can be dedicated to the new...
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
January 31, 2010 at 12:26 am
Periscope
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
January 30, 2010 at 10:49 pm
It looks like a majority of your fragmentation is in heaps. Heaps cannot be defragged. You must determine which tables are heaps. Those are the tables that...
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
January 30, 2010 at 10:46 pm
What server roles and database roles does that user belong to?
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
January 30, 2010 at 10:43 pm
Exam 70-431
Exam 70-443
Exam 70-444
Are for DBA
The others are for Database Developer.
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
January 30, 2010 at 10:41 pm
Yes you can.
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
January 30, 2010 at 10:38 pm
I would read those links suggested by Gail. Also, there is a script for download called sp_activity. That also helps to give some insight into blocking chains. ...
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
January 30, 2010 at 3:11 pm
Thanks Gail.
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
January 30, 2010 at 10:38 am
GilaMonster (1/30/2010)
george sibbald (1/30/2010)
they were? People do that?
Sure. The exceptional DBA allowed both people to nominate others and for people to nominate themselves. Lots of people will nominate themselves 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
January 30, 2010 at 10:02 am
Jeff Moden (1/30/2010)
Sounds like your design philosophy and mine are pretty much the same. When I get to a new SQL Server site, one of the things I do...
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
January 30, 2010 at 9:50 am
Paul White (1/30/2010)
GilaMonster (1/30/2010)
It's Hermes (Mercury) one of the greek gods. I believe he was the messenger of the godsThanks
Hermes - Greek
Mercury - Roman
Kind of a catch-all god. Messenger,...
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
January 30, 2010 at 9:47 am
Jeff Moden (1/29/2010)
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
January 29, 2010 at 11:39 pm
john.arnott (1/29/2010)
CirquedeSQLeil (1/29/2010)
Is it alive? Anybody have a defibrillator?Careful. It starts to be a sad thing when someone looks to the Thread for company on a Friday night....;-)
Heh...
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
January 29, 2010 at 11:35 pm
Lynn Pettis (1/29/2010)
WayneS (1/29/2010)
Lynn Pettis (1/29/2010)
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
January 29, 2010 at 5:08 pm
Thanks for updating us. As Michael pointed out, make sure you get some good backups of your databases and keep them in separate physical locations / media.
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
January 29, 2010 at 4:13 pm
Viewing 15 posts - 17,701 through 17,715 (of 19,560 total)