Viewing 15 posts - 13,216 through 13,230 (of 19,560 total)
Thanks for sharing.
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 21, 2010 at 10:38 am
douglane4 (7/21/2010)
Over time you’ll become more valuable, because you get more done, and because your tasks run smoothly.
More valuable, yes, but to whom? The only person you can truly...
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 21, 2010 at 10:20 am
I'm glad to see that I am not the only one who has considered the plenum as an access path to the server room. 😎
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 21, 2010 at 10:15 am
Well you have one batch of commands to alter the path and file location for tempdb and the other is to modify the data and log file size. 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
July 21, 2010 at 10:13 am
amenjonathan (7/21/2010)
...sometimes you have to analyze the management first to see if it's worth the effort.
I have seen this with management. You bust your butt (16+ hour days 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
July 21, 2010 at 10:09 am
OCTom (7/21/2010)
And, are you ever productive enough?
No. You increase performance and start outputting more, then they expect more.
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 21, 2010 at 9:13 am
Andy Warren (7/21/2010)
One mistake I see made (and sometimes make myself) is to try to handle 100% of possible scenarios. The 80/20 rule often applies,...
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 21, 2010 at 9:09 am
Kit G (7/19/2010)
CirquedeSQLeil (7/18/2010)
What has happened to the nefarious one called Gus?
Gus was working on a contract where web access was strictly monitored, so he didn't feel comfortable posting. ...
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 21, 2010 at 9:01 am
Could you give a little more detail?
What have you tried?
What are you really trying to accomplish (what should the end product be)?
Does the SSRS report already exist and you just...
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 20, 2010 at 11:30 pm
I find it necessary to create automation for those repetitive tasks that there is never enough time to automate. By forcing time in the schedule to automate a task...
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 20, 2010 at 11:22 pm
As Roy and Jeff have said, find what is causing the growth to occur.
Here is an article discussing how to do that.
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
July 20, 2010 at 11:15 pm
Two things to consider:
1. This is a test server.
2. You have > 32GB free space inside the data file. You have adequate room for growth within 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
July 20, 2010 at 11:13 pm
Paul White NZ (7/20/2010)
The actions of the SAN guy in some environments could be deemed detrimental to the business and even viewed as sabotage. Actions such as that carry...
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 20, 2010 at 11:09 pm
magasvs (7/20/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
July 20, 2010 at 10:52 pm
Try verifying the permissions. Some may have been updated with the upgrade to Exchange 2010.
http://support.microsoft.com/kb/293422/EN-US/
This link is for SQL 2000 - but applies to Exchange permissions.
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 20, 2010 at 3:31 pm
Viewing 15 posts - 13,216 through 13,230 (of 19,560 total)