| Author |
Topic |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
 Posted - 2010-01-18 : 03:30:11
|
N 56°04'39.26"E 12°55'05.63" |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-18 : 03:43:48
|
Looks beautiful, is it a Boy or a Girl?  |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-01-18 : 10:02:07
|
| Coool... - Lumbagohttp://xkcd.com/327/ |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-01-18 : 11:49:36
|
| Dual Quad-core with Hyper-threading?CODO ERGO SUM |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-01-18 : 12:05:40
|
Yes, 64-bit Xeons running at 2.67 GHz.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-18 : 12:23:14
|
Time to make it busy...looks like it is bored 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-01-18 : 12:33:42
|
| Our most expensive SQL system shows 16 CPUs as well. It's quad-core with 4 sockets. We went with 64GB of memory as the jump to 128GB was going to more than quadruple the cost if I recall correctly. This particular system is a 2-node cluster at the primary site and then we've got identical hardware at the DR site that is also a 2-node cluster. So when we buy one fancy system, we buy a minimum of 4 servers (cluster plus DR). Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-01-18 : 12:37:48
|
| I've always been curious who you work for Tara...any chance of telling?? - Lumbagohttp://xkcd.com/327/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-01-18 : 12:44:34
|
| I work for Qualcomm. It's hinted at in my profile in the cool links section. I work on many of the systems in this link: http://www.qualcomm.com/qes/The system has a 300 millisecond query performance for like 99% of queries. That's not so easy to do when the database is close to 1 terabyte in size. I recently described the database layout. I'll see if I can dig that post up. I mention the database is split into 21 data files and briefly describe the mount point layout.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-01-18 : 12:50:53
|
| I found the links, but I didn't go into as much detail as I thought. The 1TB database is split up into 21 data files that span across 7 mount points. Each mount point points to a different RAID controller on the dedicated SAN. On each mount point are 4 data files. 14 of the data files have a maximum size setting of 60GB. The last 7 data files are set to unlimited growth. When I get back from maternity leave in a few months, I will write a monitoring process that fires an email when the last 7 files are nearing 60GB to alert the DBA team to add an additional 7 files and cap the previous 7 to 60GB. 64GB is the actual recommendation by Microsoft for the maximum data file size. We instead used 60GB to be on the safe side. 64GB is a significant number due to some Windows sparse file issue. If you have any data files that are over 64GB, you should consider breaking it up into multiple data files. Keep adding files until all of them are under 64GB.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-01-18 : 17:38:42
|
quote:
Originally posted by webfred
Time to make it busy...looks like it is bored
Oh, I will. Right after I redesign the staging area...
N 56°04'39.26"E 12°55'05.63" |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-01-19 : 07:39:10
|
| Thanx for letting me know Tara...never heard of it but from the looks if it, it seems like you have your hands full - Lumbagohttp://xkcd.com/327/ |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2010-01-19 : 08:41:47
|
| I now cry. That is beautiful. http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2010-01-22 : 00:31:47
|
wow, i want that puppy. really want it. :)
elsasoft.org |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-02-01 : 09:54:23
|
First real-life test done.I played with Celko's new stumper; The Class Scheduling Problem.For 1,000 classes (with some class sized duplicated) and 1,000 rooms (with some room sizes duplicated) I now have a set-based algorithm (thanks to Ryan Randall) that runs in 250 ms!My cursor approach runs in 5 seconds.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-02-01 : 10:10:02
|
| I assume you're talking about this:http://www.sqlservercentral.com/articles/The+Class+Scheduling+Problem/69387/Going for the win?? - LumbagoIf the facts don't fit the theory, change the facts. Albert Einstein |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-02-01 : 11:08:39
|
Not really. I have won the competition twice already.I haven't got Celko's books, so I can't compare his earlier approaches. But in this competitio he wanted to modernize the code to use the new windows functions.I doubt the old approaches will run in 250 ms or less on my machine.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-02-02 : 02:15:07
|
| 3 times'a charm, isn't that what they say? I know you won a few of these competitions already, I just didn't realize that it was the same one with different criteria.- LumbagoIf the facts don't fit the theory, change the facts. Albert Einstein |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-02-02 : 03:46:02
|
The Stumpers are based on somewhat real-life problems and to find the most efficient approach to solve them.I was awarded the Speed Phreak award for the stumper "Prime Numbers" which started the Pgil Factor series of which I won "Subscription List Problem" and hosted the "FIFO Stock Inventory Problem" (couldn't compete myself).Please join in on these competitions. They are really fun. Not only because of the competition themself, but due to the collaborative learning process.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
Next Page
|
My new baby has arrived