Viewing 15 posts - 13,921 through 13,935 (of 19,560 total)
I would focus on 2008 more than 2005.
I also like the recommendation to use SQLShare rather than New Horizons. I haven't been too impressed by any course that 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
May 19, 2010 at 2:14 pm
Hmmm - I have not tried that.
Just went out and tried - blocked as well. His blog is not blocked, but his Ustream is.
I will have to find a...
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
May 19, 2010 at 2:05 pm
Jack Corbett (5/19/2010)
Quiet in here today. Everyone at 24 HOP?
I wish - it is blocked here at work and I forgot to get the request in for access to...
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
May 19, 2010 at 1:56 pm
I wonder if it may be out of date statistics.
You could try running an sp_updatestats. This may have an effect on your results. Also, I am curious 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
May 19, 2010 at 1:55 pm
These tables will increase in size based on your database and the number of objects in your database.
You don't need to do anything with these.
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
May 19, 2010 at 1:05 pm
The rowcount piece is accurate in your script. The calculation of size is not. The calculation you use shows a difference of 20% in size for my 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
May 19, 2010 at 12:51 pm
Based on the sample data, I might be inclined to think that those are a bit high. Please post the query you are using to determine those sizes.
Also, 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
May 19, 2010 at 12:32 pm
Yang-703993 (5/19/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
May 19, 2010 at 12:15 pm
For the objects of type 'S' in each of the user databases, they really don't need and shouldn't need much maintenance.
For the additional objects such as dmvs, some of 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
May 19, 2010 at 12:14 pm
Nice article and great discussion.
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
May 19, 2010 at 11:57 am
You can try the supplemental content download
http://examples.oreilly.com/9780735623422/
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
May 19, 2010 at 11:50 am
I've done it before without repercussions.
Here is also somebody else who has done 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
May 19, 2010 at 11:48 am
Thanks Bru.
If you need help finding what is causing the log growth, you can check out my article on the topic.
http://www.sqlservercentral.com/articles/Log+growth/69476/
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
May 19, 2010 at 11:43 am
Thanks Gail. Well hidden is a bit of an understatement.:-)
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
May 19, 2010 at 11:40 am
DBCC Shrinkfile should be fine.
The second part of this question is to find out what caused your log file to grow to 50GB. Some process ran away and caused...
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
May 19, 2010 at 11:23 am
Viewing 15 posts - 13,921 through 13,935 (of 19,560 total)