Forum Replies Created
Viewing 15 posts - 4,861 through 4,875 (of 22,227 total)
-
RE: The mystery of high memory usage
SQL Server will use every bit of memory you assign to it. It'll store data in cache and keep it there as long as it can in order to avoid...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Capturing all SQL Statements Hitting the database of server
Least cost to do this is extended events. However, since you're in 2008, there is no GUI for consuming the results (or setting things up). You'll need to query XML...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Third Party Backup - Asigra - experience
gdrummer83 (4/11/2016)
I have been using Asigra for a little over 2 years. I like the interface and think it's pretty streamlined and to the point. Not only that,..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Stored Procedure running Indefinateley
Sean Lange (4/11/2016)
skb 44459 (4/11/2016)
Can you post execution plans?
- Execution plan says. Query Cost 'Relative to batch) : 50%
Stating the relative cost of the batch when compared to the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Quick design question
Modify the database. Anything else you do is going to be bandaid that creates technical debt. Technical debt, like any kind of debt, adds up and will disable you eventually....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Third Party Backup - Asigra - experience
Also no experience with Asigra backup.
However, I can tell you one thing about ANY third party backup, make them do a restore. Make them do a point in time restore....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Discontinued features in SQL 2012/2014
It depends on what we're talking about. If we're talking features that are now on the deprecation list, they just haven't been removed yet. If we're talking features that have...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
BL0B_EATER (4/8/2016)
Would anyone find an article on Azure's SQL elastic pools worth reading? More on the basic setup and screen navigation? Just to understand where you would add a..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: How to Get Query Plan During Execution
The plan is stored before execution completes, but it's stored just before execution starts. You're trying to capture the plan before execution. There's no way to do that without running...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: monitoring deadlocks in sql server 2014
Not sure where you're getting that traceflags have to be set to work with extended events. As Gail says, that isn't true.
If I were going to use extended events to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
SQLRNNR (4/7/2016)
Grant Fritchey (4/7/2016)
I'm wrestling with an Octopus.How are you faring against all of those arms?
Winning!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Deadlock graph/report experts wanted :)
Brandie Tarvin (4/7/2016)
Grant Fritchey (4/7/2016)
Since you're on SQL Server 2012, have you tried using extended events to capture query metrics? They're not free (nothing is, TANSTAAFL always applies), but they..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Deadlock graph/report experts wanted :)
TheSQLGuru (4/7/2016)
Brandie Tarvin (4/7/2016)
Grant Fritchey (4/7/2016)
Since you're on SQL Server 2012, have you tried using extended events to capture query metrics? They're not free (nothing is, TANSTAAFL always applies), but..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
I'm wrestling with an Octopus install gone horribly wrong.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: parallel query with AWS RDS sqlserver
A single query across multiple instances can be done many different ways (AWS or not).
You can look to Multi-Server Management utilities. You can do linked servers, but you're just going...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 4,861 through 4,875 (of 22,227 total)