Viewing 15 posts - 18,751 through 18,765 (of 19,560 total)
BEAR
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
December 14, 2009 at 9:25 am
Alvin Ramard (12/14/2009)
GSquared (12/14/2009)
CirquedeSQLeil (12/11/2009)
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
December 14, 2009 at 9:23 am
GSquared (12/14/2009)
CirquedeSQLeil (12/11/2009)
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
December 14, 2009 at 9:21 am
SQLAGENT$SQLSERVERVIEW is The SQL Agent Service that controls your SQL Jobs. Since your 3rd party app relies on some jobs to keep DB trimmed and cleaned out, you should...
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
December 14, 2009 at 9:19 am
Doh - version based question where the results change.
SSMS 2005 and 2008 both gave me 3.4
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
December 13, 2009 at 10:33 pm
If you find that you need to compare rowsets to verify that data truly is in sync, then a third party tool like Steve suggested would be ideal.
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
December 13, 2009 at 8:33 pm
The default will depend on your server configurations. If your model DB is set to full recovery - then you will get full recovery when you install your DB.
As...
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
December 13, 2009 at 8:16 pm
Chan Wai Yin (12/13/2009)
CirquedeSQLeil (12/12/2009)
If full, you should do a full db backup and then schedule transaction log backups.
Once the transaction log has been backed...
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
December 13, 2009 at 6:49 pm
Jeff Moden (12/13/2009)
Matt Miller (#4) (12/13/2009)
Jeff Moden (12/12/2009)
Steve Jones - Editor (12/12/2009)
And here I think Barry would like this carMan, I used to love "Spanky and his gang".
Oh - were...
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
December 13, 2009 at 6:42 pm
Pandora
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
December 13, 2009 at 4:29 pm
GilaMonster (12/13/2009)
The Dixie Flatline (12/12/2009)
Too rainy to play outside today, but we went to see "Invictus".Rugby players eat their dead.
I saw the preview for that. Brought back some memories. 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
December 13, 2009 at 2:42 pm
RBarryYoung (12/13/2009)
Grant Fritchey (12/13/2009)
RBarryYoung (12/13/2009)
Grant Fritchey (12/13/2009)
RBarryYoung (12/12/2009)
Oops!Congrats Barry.
I can't decide if "oops" is incredibly sad or absolutely appropriate for the 10,000th post.
Actually its the word most often said immediately...
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
December 13, 2009 at 2:40 pm
Steve Jones - Editor (12/12/2009)
And here I think Barry would like this car
Nice
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
December 12, 2009 at 8:26 pm
TheSQLGuru (12/11/2009)
CirquedeSQLeil (12/11/2009)
DP stands for double-parity.
From the NetApp docs
The performance of RAID-DP volumes is comparable to that of...
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
December 12, 2009 at 11:56 am
Please attach the actual execution plan, filegroup structure, and hard disk configs (Raid level)
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
December 12, 2009 at 11:52 am
Viewing 15 posts - 18,751 through 18,765 (of 19,560 total)