Viewing 15 posts - 4,351 through 4,365 (of 22,219 total)
Since you're in 2014, use extended events. You should absolutely be able to capture the parameter values on individual calls. If rpc_complete is not giving you the information you're looking...
"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
October 4, 2016 at 7:47 am
There is not currently a mechanism released for querying Azure databases from the Portal UI. However, you can try clicking on the Tools menu from a given database. There are...
"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
October 3, 2016 at 10:47 am
Yeah, it's normal. Here's the description of that procedure. A suspended status just means that at the moment you're calling it, it's waiting on resources and will restart when it's...
"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
October 3, 2016 at 6:05 am
george sibbald (10/3/2016)
not used it myself but wondering if dacpac will help herehttps://msdn.microsoft.com/en-gb/library/ee210546(v=sql.110).aspx
right click database, tasks, extract data-tier application
That could work, but you're going to want to automate it too...
"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
October 3, 2016 at 6:01 am
If you only want to move all the structures and no data, I'd suggest taking a look at SQL Compare [/url]from Redgate (disclosure: my employer). If I had 700+ databases...
"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
October 3, 2016 at 4:26 am
Hugo Kornelis (10/2/2016)
Eirikur Eiriksson (10/2/2016)
BLOB_EATER (10/2/2016)
Into my 19th hour for the weekend shift decided to google (Gone off bing) well know SQL Server people and found this (attached).... Im scared.
Don't...
"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
October 3, 2016 at 4:14 am
You also won't be able to do a backup and restore going down in versions.
"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 30, 2016 at 8:26 am
djj (9/30/2016)
Greg Edwards-268690 (9/29/2016)
Setting them up in several stages, where you can avoid...
"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 30, 2016 at 5:23 am
Sounds like you're doing a good job. Keep it up. Focus on the metrics to drive your decisions. Take a look at Gail Shaw's blog post on "catch-all" queries. That...
"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 29, 2016 at 12:12 pm
Mike Scalise (9/29/2016)
Grant Fritchey (9/29/2016)
I did set up a Powershell script once that spawned threads to run multiple backups simultaneously. I'll never do...
"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 29, 2016 at 12:06 pm
PiMané (9/29/2016)
It's best to take the reads vs writes in consideration rather than the missing index then, right?
Yes & no. It really comes down to pain points. Not every query...
"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 29, 2016 at 7:02 am
Without all the details, what I'm about to say should be taken with a large grain of salt...
I'd be inclined to do any updates directly against the table in question,...
"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 29, 2016 at 6:37 am
Of course using Redgate tools is the ultimate answer. SQL Monitor would be the one to use in this situation. You can link to a server without installing anything to...
"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 29, 2016 at 6:25 am
I'd just do them one after another.
I did set up a Powershell script once that spawned threads to run multiple backups simultaneously. I'll never do that to a production...
"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 29, 2016 at 6:14 am
I'm not sure it's 2014. I know 2016 is free. Here's the link.
"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 29, 2016 at 6:12 am
Viewing 15 posts - 4,351 through 4,365 (of 22,219 total)