Viewing 15 posts - 2,461 through 2,475 (of 19,560 total)
Koen Verbeeck (7/31/2014)
ChrisM@Work (7/31/2014)
Koen Verbeeck (7/31/2014)
Lynn Pettis (7/31/2014)
Lynn Pettis (7/31/2014)
SQLRNNR (7/30/2014)
Lynn Pettis (7/30/2014)
Really?? Let's put a 500 million row table into an in-memory table.
It could work - depending on what...
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 31, 2014 at 7:54 am
Koen Verbeeck (7/31/2014)
Lynn Pettis (7/31/2014)
Lynn Pettis (7/31/2014)
SQLRNNR (7/30/2014)
Lynn Pettis (7/30/2014)
Really?? Let's put a 500 million row table into an in-memory table.
It could work - depending on what the data is...
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 31, 2014 at 7:50 am
GilaMonster (7/31/2014)
Lynn Pettis (7/31/2014)
Okay, he has the memory;Size of the table: 195 GB
Number of Indexes: 90
220GB memory is allocated only for the sql server....out of total 260 GB Server memory
No...
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 31, 2014 at 7:49 am
With 90 indexes you are over a constraint right there.
You are limited in number of indexes (8 iirc) you can create on an in-memory table.
With the table being 195GB, 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
July 31, 2014 at 7:48 am
What is the size of your table?
How many indexes?
And is that 220GB allocated explicitly to SQL Server or is that what is available to the server? If explicitly, how...
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 30, 2014 at 10:06 pm
Lynn Pettis (7/30/2014)
Really?? Let's put a 500 million row table into an in-memory table.
It could work - depending on what the data is in that table and the data types....
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 30, 2014 at 10:02 pm
I believe you are going about this the wrong way.
How big is your table with 500 million records?
How many indexes do you plan to have on that table?
How much memory...
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 30, 2014 at 9:02 pm
Lynn Pettis (7/30/2014)
Jeff Moden (7/30/2014)
autoexcrement (7/30/2014)
How about "crap answers only"?Heh... maybe that would make a good alternative to "The Thread". 😀
Careful, we don't want to provoke The Thread. ...
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 30, 2014 at 8:48 pm
Good Question.
I do think the answer is a dead give away if you have familiarity with sys.objects though.
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 30, 2014 at 8:45 pm
Recap...
So restore database with backup on NAS = fail
Restore database with backup on backend storage = fail
Restore database from vendor backup = fail
Restore database from newly created backup after vendor...
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 30, 2014 at 7:00 pm
Evil Kraig F (7/30/2014)
SQLRNNR (7/30/2014)
Sadly I have heard that same recommendation from more than one vendor and it is even printed in some vendor documentation for databases on SQL Server.
From...
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 30, 2014 at 4:39 pm
Sadly I have heard that same recommendation from more than one vendor and it is even printed in some vendor documentation for databases on SQL Server.
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 30, 2014 at 4:32 pm
Sean Lange (7/30/2014)
Ed Wagner (7/30/2014)
SQLRNNR (7/30/2014)
djj (7/30/2014)
whereisSQL? (7/30/2014)
Ed Wagner (7/30/2014)
TomThomson (7/30/2014)
SQLRNNR (7/30/2014)
Ed Wagner (7/30/2014)
Stuart Davies (7/30/2014)
SQLRNNR (7/29/2014)
aardvarkDigger
Hunting (for antiques)
Pecheur
é or ê?
Tomato
ketchup
hot dog
breakfast
Dinner
Bacon
Pork Belly
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 30, 2014 at 3:14 pm
Try these guys...
http://www.sqlskills.com/sql-server-training/
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 30, 2014 at 3:14 pm
Evil Kraig F (7/30/2014)
Steve Jones - SSC Editor (7/30/2014)
Lynn Pettis (7/30/2014)
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 30, 2014 at 3:08 pm
Viewing 15 posts - 2,461 through 2,475 (of 19,560 total)