Viewing 15 posts - 12,346 through 12,360 (of 22,224 total)
I'm curious what performance issues you've seen with Red Gate SQL Monitor?
I work for the company and we're constantly trying to improve the product. If you have some specific...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 13, 2011 at 8:29 am
How do you mean? Do you want alerts when there are errors? You can configure this using Alerts in SQL Agent.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 13, 2011 at 8:27 am
No, something else must be occurring. I'm with the Ninja, I'd need to plan to understand.
Just a guess, you added the index and then reran the query? Unless you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 13, 2011 at 8:25 am
Why are you trying to drop one of the system procs? I'd leave that alone.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 13, 2011 at 5:30 am
GilaMonster (6/13/2011)
Anyone noticed that we now have pretty pictures as well as alphabet soup? http://www.sqlservercentral.com/Forums/Topic1123813-359-1.aspx
The soup has been strained though. Improvements.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 13, 2011 at 4:53 am
John Mitchell-245523 (6/13/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 13, 2011 at 3:58 am
If all you're looking for is a count of statements, I'd go with just pulling the data out of performance monitor then. It's standard set of data. As long as...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 13, 2011 at 3:43 am
I can't tell you what backward recovery is, never heard of that one.
Rollback or rollforward is referring to transactions. A rollback on a transaction is to undo whatever that transaction...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 12, 2011 at 8:15 am
aaa-322853 (6/12/2011)
I wanted to provide somekind of update to where my findings have led me, any feedback is welcome as always.
So I posted...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 12, 2011 at 6:06 am
You can use the Data Collector if you have Enterprise edition. That will collect disk usage for you and is built into SQL Server.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 12, 2011 at 5:00 am
And if you go to Tools -> Options -> SQL Server Object Explorer -> Scripting, you can exercise some control over how scripts are generated.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 12, 2011 at 4:57 am
Yasir Masood (6/11/2011)
That worked. Thank you
Not a problem. Glad I could help. Also, thanks for posting that it worked. Makes it better for someone reading this later.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 11, 2011 at 10:00 am
Not having your data, it's hard for me test this, but you can try moving the other WHERE criteria into the JOIN clause. When dealing with OUTER JOINs, filter criteria...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 11, 2011 at 9:26 am
muthukkumaran Kaliyamoorthy (6/11/2011)
ting.kris (6/11/2011)
Spam. Please don't respond.
You don't need to do that. Just click on the Report button and ignore the post otherwise.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 11, 2011 at 5:52 am
shiv-356842 (6/11/2011)
Hi Team,What is difference between Migration and Upgradation... please guide me.
Tx
I'm not sure what context you're asking the question, but here's my swipe at an answer.
A migration is moving...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 11, 2011 at 5:51 am
Viewing 15 posts - 12,346 through 12,360 (of 22,224 total)