Viewing 15 posts - 15,196 through 15,210 (of 19,560 total)
Steve Jones - Editor (4/6/2010)
Added a couple more. I'll see if I can get a few more done to go out to 50k
What are these new levels that currently only...
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
April 7, 2010 at 1:28 am
Along with the query plans, include the query itself.
One thing that could be a difference comes down to server hardware configuration. You may want to verify and re-verify that...
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
April 7, 2010 at 1:26 am
Are you getting any error messages along with the slowdown or are you just experiencing general slowness? Are you seeing application timeouts?
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
April 7, 2010 at 1:22 am
RBarryYoung (4/7/2010)
Yep, Morton-Thiokol was pretty notorious back then (having made the O-rings and boosters that resulted in the Challenger explosion), but I've heard that they're much improved these days.
I think...
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
April 7, 2010 at 1:19 am
Let us know the answers to Henrico's questions.
Also, is Drive D formatted as NTFS or some other file system?
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
April 7, 2010 at 1:18 am
kwoznica (2/9/2009)
Is there any trick I can employ...
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
April 7, 2010 at 1:14 am
kwoznica (2/9/2009)
All,Is there a way to find out what could be causing the recent spike in log file growth once reorganize is run?
I recommend you read the following...
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
April 7, 2010 at 1:13 am
I think the consideration for memory and cpu is one of those "it depends" situations. Memory is so cheap these days. And if you are buying a new...
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
April 7, 2010 at 1:09 am
RBarryYoung (4/7/2010)
WayneS (4/6/2010)
Does anyone else around here feel like a rocket scientist?[/u]
It depends, how does a Rocket Scientist feel? 😛
Actually, I did do some work for a NASA project...
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
April 7, 2010 at 1:05 am
If the statistics are vital, and you have autoupdate statistics on - you should be ok. The system should recreate what is necessary.
As for the indexes - I would...
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
April 7, 2010 at 12:59 am
Do you have good backups of the database?
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
April 7, 2010 at 12:55 am
I would look at partitioning the table. Check that out in BOL. It could be a performance saver for you.
Also, you should check the query being used for...
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
April 7, 2010 at 12:54 am
One of the big considerations is licensing. Another consideration is performance. In my current environment we have SSIS, SSAS,SSRS, and SQL Server installed on the same server in...
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
April 7, 2010 at 12:51 am
If there are operations already being performed on those tables at the time you start the rebuild / reorganize, then you will see a delay. Rebuilding and reorganizing 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
April 7, 2010 at 12:48 am
Nice article Seth. I will be adding this article to my arsenal.
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
April 7, 2010 at 12:45 am
Viewing 15 posts - 15,196 through 15,210 (of 19,560 total)