Viewing 15 posts - 4,426 through 4,440 (of 22,224 total)
Ken McKelvey (9/16/2016)
Further to Grant's post, even some basic monitoring of Latency, Waits and PLE once a month will show the way instances are heading:http://www.sqlskills.com/blogs/paul/how-to-examine-io-subsystem-latencies-from-within-sql-server/
http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/
http://blog.sqlauthority.com/2010/12/13/sql-server-what-is-page-life-expectancy-ple-counter/
I'd shy away from PLE. By...
"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
September 16, 2016 at 8:00 am
SQL Clone will certainly help, but you'd still want to get the allocated space of the database down prior to using SQL Clone.
If shrink isn't going to work, and...
"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
September 16, 2016 at 5:55 am
If you don't have monitoring in place, then I would start with capturing the wait statistics over time. You need to be able to compare them, today to yesterday, this...
"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
September 16, 2016 at 5:48 am
Are you experiencing any other issues related to memory or disk? What are your top wait statistics? Are you experiencing performance issues. PLE, all by itself, doesn't really indicate much...
"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
September 16, 2016 at 5:41 am
Nope.
A temporary table is isolated by the connection that created it.
"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
September 14, 2016 at 9:08 am
Bharat21 (9/14/2016)
1.Query for List of tables of top and bottom accessed in last 30 days
2. Query for List of stored procedures 10% of top...
"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
September 14, 2016 at 6:42 am
If you are going to do dynamic SQL, then please, use sp_executesql and use parameter values. Don't let unchecked string parameters determine behaviors. That leads to SQL Injection. When 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
September 14, 2016 at 4:11 am
Jacob Wilkins (9/13/2016)
"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
September 13, 2016 at 8:13 pm
That's only one query plan. You'd need to post the plan from the application and the plan from the code that you're running both in order to see if there...
"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
September 13, 2016 at 12:01 pm
BLOB_EATER (9/13/2016)
Grant Fritchey (9/13/2016)
"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
September 13, 2016 at 8:42 am
I'm around 10,000 a month, give or take. I think that's about 300+ a day on week days. I know the big SQL Server bloggers like Brent or Paul &...
"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
September 13, 2016 at 8:09 am
Another approach to get as near to simultaneous as possible would be to use Powershell where you can spawn multiple threads on the machine. The degree to which these things...
"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
September 13, 2016 at 3:30 am
I'd test it using a parameter, not a local variable. Most of the time, but clearly not always, parameter sniffing is a good thing and helps performance. It really depends...
"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
September 12, 2016 at 4:02 am
John Mitchell-245523 (9/12/2016)
"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
September 12, 2016 at 3:59 am
IF the logs are getting bigger you have more, or longer running, transactions. Log backups can only remove from the log those transactions that are complete. If you have a...
"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
September 12, 2016 at 3:57 am
Viewing 15 posts - 4,426 through 4,440 (of 22,224 total)