June 15, 2011 at 12:38 pm
Roy Ernest (6/15/2011)
Our user group is planning to have a SQL Saturday in our tiny island. We are aiming for 25th of February, 2012. It is the week after the Carnival. Start making plans everyone. 🙂
Wow. That's a perfect excuse for a vacation.
June 15, 2011 at 12:45 pm
Brandie Tarvin (6/15/2011)
Roy Ernest (6/15/2011)
Our user group is planning to have a SQL Saturday in our tiny island. We are aiming for 25th of February, 2012. It is the week after the Carnival. Start making plans everyone. 🙂Wow. That's a perfect excuse for a vacation.
Indeed. I'll mark the calendar
June 15, 2011 at 12:47 pm
Brandie Tarvin (6/15/2011)
Roy Ernest (6/15/2011)
Our user group is planning to have a SQL Saturday in our tiny island. We are aiming for 25th of February, 2012. It is the week after the Carnival. Start making plans everyone. 🙂Wow. That's a perfect excuse for a vacation.
Queue the beach boys... Aruba, Jamaica ewww I want to take you to ...
That's a SQL Saturday I'd go to if I had the cash to do it. I've been to Aruba several times and would love to return.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
June 15, 2011 at 12:51 pm
jcrawf02 (6/15/2011)
Funny story for your amusement:Last Saturday I attended my first SQL Sat in Columbus, and thoroughly enjoyed it. I had seen a tweet the day before in passing, where Jason said he was going to be in town attending a wedding, and so was coming to SQLSat75.
Spent half the day looking for him, only to eventually figure out that it was Allen White tweeting (SQLRunr), not Jason (SQLRNNR).
D'oh!
Stupid twitter handles...
Allen is very good company too.:cool:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 15, 2011 at 12:54 pm
Stefan Krzywicki (6/15/2011)
Anyone have opinions about putting a data warehouse on a VM? The main objection I have so far is speed, even without a VM our server isn't all that fast and they're not going to be willing to pay for a faster machine just so they can VM it. If you can direct me to some literature on why this is a bad idea, I'd appreciate it.
BI tends to have more variation in workload.
So if they plan to VM it, the big question might be on resources.
Our network admin used to talk about our machine being underutilized.
24 hour average CPU was 30%.
Then we pointed out our processing - almost 5 hours, 100%, taking up most of out nightly window.
Processing peaks / window, and user access peaks are part of the picture.
Averages might not work very well.
Part of you decision might rest with version of OS and SQL, and if it's strictly used for SQL or you have Cubes too.
Somewhere I also have a doc talking about BI and virtualizing, where you might consider 2 to 1 good vs. 10 - 20 normal for other applications.
2008 R2 (both SQL and OS), and splitting SQL and SSAS to separate servers (physical) worked very well for us.
June 15, 2011 at 1:00 pm
Brandie, it is the perfect place for a vacation. 🙂
Steve, I will expecting you for sure. Trey, there is lots of time to save money for the trip. That is why I announced it more than 6 months in advance. 🙂
-Roy
June 15, 2011 at 1:22 pm
Greg Edwards-268690 (6/15/2011)
Stefan Krzywicki (6/15/2011)
Anyone have opinions about putting a data warehouse on a VM? The main objection I have so far is speed, even without a VM our server isn't all that fast and they're not going to be willing to pay for a faster machine just so they can VM it. If you can direct me to some literature on why this is a bad idea, I'd appreciate it.BI tends to have more variation in workload.
So if they plan to VM it, the big question might be on resources.
Our network admin used to talk about our machine being underutilized.
24 hour average CPU was 30%.
Then we pointed out our processing - almost 5 hours, 100%, taking up most of out nightly window.
Processing peaks / window, and user access peaks are part of the picture.
Averages might not work very well.
Part of you decision might rest with version of OS and SQL, and if it's strictly used for SQL or you have Cubes too.
Somewhere I also have a doc talking about BI and virtualizing, where you might consider 2 to 1 good vs. 10 - 20 normal for other applications.
2008 R2 (both SQL and OS), and splitting SQL and SSAS to separate servers (physical) worked very well for us.
Thanks, I just need to know what to look at and what questions to ask. This should help quite a bit.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
June 15, 2011 at 1:37 pm
ALZDBA (6/15/2011)
jcrawf02 (6/15/2011)
Funny story for your amusement:Last Saturday I attended my first SQL Sat in Columbus, and thoroughly enjoyed it. I had seen a tweet the day before in passing, where Jason said he was going to be in town attending a wedding, and so was coming to SQLSat75.
Spent half the day looking for him, only to eventually figure out that it was Allen White tweeting (SQLRunr), not Jason (SQLRNNR).
D'oh!
Stupid twitter handles...
Allen is very good company too.:cool:
Allen is GREAT company. It doesn't feel like a SQL event when he's missing.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 15, 2011 at 2:42 pm
OK, here are the current top posters:
SQLRNNR - 2567
GilaMonster - 1957
Lynn Pettis - 1775
Alvin Ramard - 1745
Steve Jones - SSC Editor - 1434
Grant Fritchey - 1427
Jeff Moden - 1258
GSquared - 1046
The Dixie Flatline - 997
SQLkiwi - 980
I was going to cut off at 1000, but Bob was so close that I went to 10.
There are 105 different people that have posted here, just under a hundred with only 1 post.
Posting is also surprisingly consistent
Year Mn Posts
20116506
20115763
20114812
20113888
20112740
20111798
201012824
201011972
2010101457
201091613
201081057
20107833
20106492
20105582
201041325
201031575
201021139
20101568
200912810
200911625
200910674
20099508
20098690
20097772
200961167
200951284
20094740
200931018
20092993
20091603
200812364
200811161
June 15, 2011 at 3:00 pm
Steve Jones - SSC Editor (6/15/2011)
...There are 105 different people that have posted here, just under a hundred with only 1 post.
105 different people with more than 1 post plus 100 with only 1 post?
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
June 15, 2011 at 3:01 pm
Steve Jones - SSC Editor (6/15/2011)
OK, here are the current top posters:SQLRNNR - 2567
GilaMonster - 1957
Lynn Pettis - 1775
Alvin Ramard - 1745
Steve Jones - SSC Editor - 1434
Grant Fritchey - 1427
Jeff Moden - 1258
GSquared - 1046
The Dixie Flatline - 997
SQLkiwi - 980
I was going to cut off at 1000, but Bob was so close that I went to 10.
There are 105 different people that have posted here, just under a hundred with only 1 post.
Posting is also surprisingly consistent
Year Mn Posts
20116506
20115763
20114812
20113888
20112740
20111798
201012824
201011972
2010101457
201091613
201081057
20107833
20106492
20105582
201041325
201031575
201021139
20101568
200912810
200911625
200910674
20099508
20098690
20097772
200961167
200951284
20094740
200931018
20092993
20091603
200812364
200811161
Well it looks like it is time for a thread sabbatical.
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
June 15, 2011 at 3:06 pm
SQLRNNR (6/15/2011)
Steve Jones - SSC Editor (6/15/2011)
OK, here are the current top posters:SQLRNNR - 2567
GilaMonster - 1957
Lynn Pettis - 1775
Alvin Ramard - 1745
Steve Jones - SSC Editor - 1434
Grant Fritchey - 1427
Jeff Moden - 1258
GSquared - 1046
The Dixie Flatline - 997
SQLkiwi - 980
I was going to cut off at 1000, but Bob was so close that I went to 10.
There are 105 different people that have posted here, just under a hundred with only 1 post.
Posting is also surprisingly consistent
Year Mn Posts
20116506
20115763
20114812
20113888
20112740
20111798
201012824
201011972
2010101457
201091613
201081057
20107833
20106492
20105582
201041325
201031575
201021139
20101568
200912810
200911625
200910674
20099508
20098690
20097772
200961167
200951284
20094740
200931018
20092993
20091603
200812364
200811161
Well it looks like it is time for a thread sabbatical.
So all and all you're barely above 7K posts?
:w00t:
June 15, 2011 at 3:08 pm
SQLRNNR (6/15/2011)
Steve Jones - SSC Editor (6/15/2011)
OK, here are the current top posters:SQLRNNR - 2567
GilaMonster - 1957
Lynn Pettis - 1775
Alvin Ramard - 1745
Steve Jones - SSC Editor - 1434
Grant Fritchey - 1427
Jeff Moden - 1258
GSquared - 1046
The Dixie Flatline - 997
SQLkiwi - 980
I was going to cut off at 1000, but Bob was so close that I went to 10.
There are 105 different people that have posted here, just under a hundred with only 1 post.
Posting is also surprisingly consistent
Year Mn Posts
20116506
20115763
20114812
20113888
20112740
20111798
201012824
201011972
2010101457
201091613
201081057
20107833
20106492
20105582
201041325
201031575
201021139
20101568
200912810
200911625
200910674
20099508
20098690
20097772
200961167
200951284
20094740
200931018
20092993
20091603
200812364
200811161
Well it looks like it is time for a thread sabbatical.
Naw you just need to make up 2567 posts on other threads.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
June 15, 2011 at 4:06 pm
I'm shocked that I didn't have at least 1000 posts, but at least I'm still in the top 10. 😛
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 15, 2011 at 4:13 pm
The Dixie Flatline (6/15/2011)
I'm shocked that I didn't have at least 1000 posts, but at least I'm still in the top 10. 😛
I think that is due to your long hiatus.
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
Viewing 15 posts - 27,346 through 27,360 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply