Viewing 15 posts - 17,176 through 17,190 (of 19,560 total)
With it being 2U, I would hold out hope that you could add at least add more drives. There should be a couple of bays. For DR purposes...
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
February 17, 2010 at 9:48 pm
Paul White (2/17/2010)
Roy Ernest (2/17/2010)
I think I am the only one who does not use a Blackberry or an Iphone... 😀
I also have a mobile phone - it's mobile, and...
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
February 17, 2010 at 9:14 pm
Let's see, Raid 1 or no raid at all.
Raid 1 will impact performance. Having OS on same drives as database files will impact performance. Running Virus Scan will...
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
February 17, 2010 at 9:02 pm
Jeff Moden (2/17/2010)
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
February 17, 2010 at 8:43 pm
Alvin Ramard (2/17/2010)
CirquedeSQLeil (2/17/2010)
Alvin Ramard (2/17/2010)
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
February 17, 2010 at 8:37 pm
Alvin Ramard (2/17/2010)
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
February 17, 2010 at 6:56 pm
When running the query on the server, do you experience any cpu usage spikes? Are there disk io spikes as well during query usage?
What is the size of your...
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
February 17, 2010 at 6:44 pm
Two options:
Run a trace on your system and try to find what is running at the same time that spotlight kicks out that error message
or
Check with SpotLight and see if...
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
February 17, 2010 at 6:27 pm
I think I would likely go with the temp table. But I would test both first. It would depend on how you join the tables - assuming it...
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
February 17, 2010 at 6:18 pm
Alvin Ramard (2/17/2010)
RBarryYoung (2/17/2010)
CirquedeSQLeil (2/17/2010)
74% incorrect for Paul Randal's question on Checksum. Numbers are similar to his question the other...
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
February 17, 2010 at 6:13 pm
What are the indexes on those two tables?
Looking at the execution plans once again, I noticed that the plan from the server does not contain an output list, nor 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
February 17, 2010 at 6:11 pm
Amazing how that happens. Paul has the answers in a blog on his site. One just has to look.
It is also something that I found interesting with 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
February 17, 2010 at 6:04 pm
Alvin Ramard (2/17/2010)
CirquedeSQLeil (2/17/2010)
Anybody want to chime in on this one?Why would anybody question doing something so simple????
1 good reason is a lack of confidence. Did you notice 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
February 17, 2010 at 5:17 pm
Has anyone noticed the success/failure rate on the QOD today?
74% incorrect for Paul Randal's question on Checksum. Numbers are similar to his question the other day.
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
February 17, 2010 at 5:15 pm
Jeffrey Williams-493691 (2/17/2010)
GT's
K - I thought the same but figured mine could use more explaining too.
Thanks Jeff.
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
February 17, 2010 at 5:14 pm
Viewing 15 posts - 17,176 through 17,190 (of 19,560 total)