Viewing 15 posts - 13,306 through 13,320 (of 19,560 total)
Stephen Hirsch (7/14/2010)
...je ne regrette rien...:-P
Ah bon. Vous parlez francais aussi?
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
July 14, 2010 at 6:32 pm
OS drives are typically separate drives for the DAS bays.
You may even want to consider using RAID 5 for the ODS and logs.
It will largely depends on usage patterns, bottlenecks...
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
July 14, 2010 at 6:25 pm
boxta (7/14/2010)
d: Staging / ODS data (RAID 10?)
e: DW data (RAID 10?)
f: Index (won't...
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
July 14, 2010 at 6:14 pm
This document seems like it may be of use for you. Have you seen it?
http://msdn.microsoft.com/en-us/library/ms730088.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
July 14, 2010 at 6:05 pm
You are mixing index structures with index types and also mixing that with index components.
I think this article will help to distinguish the differences and help to understand the different...
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
July 14, 2010 at 6:00 pm
1. Could you provide more sample data with which to test?
2. Can a manager of usera also report to usera for a different project?
3. Since this also...
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
July 14, 2010 at 5:38 pm
LutzM (7/14/2010)
OUCH!!!!I immediately blacklist vendors with such a philosophy as soon as I'm getting aware of it...
I agree with you on that one.
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
July 14, 2010 at 4:23 pm
Thats what you mean?
I thought you meant a fear of pants
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
July 14, 2010 at 3:32 pm
jcrawf02 (7/14/2010)
Paul White NZ (7/14/2010)
Gianluca Sartori (7/14/2010)
Ah! I'll make sure to remember next year and maybe have a thread of mine waiting for an answer... 😀Gifts help 😀
Gift Peddies?
Ouch
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
July 14, 2010 at 11:19 am
Thanks for the Question.
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
July 14, 2010 at 10:04 am
jurisprudence
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
July 14, 2010 at 9:59 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
July 14, 2010 at 9:58 am
It seems that the cloud and VMs could really benefit from true load balancing in SQL Server. When that finally happens, then we have quite a potential for 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
July 14, 2010 at 12:57 am
Thanks Steve. This is yet another poignant reminder in the realm of goal setting.
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
July 14, 2010 at 12:43 am
Option 2 is probably the most common. It is pretty reliable and you may already have access to the history of the backups allowing you to pull a trend...
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
July 14, 2010 at 12:22 am
Viewing 15 posts - 13,306 through 13,320 (of 19,560 total)