Viewing 15 posts - 5,131 through 5,145 (of 22,219 total)
Yeah, I'd go with option 1.
However, are these different databases currently on different development and release cycles? If so, putting them all into a single database might prove to be...
"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
February 10, 2016 at 5:06 am
I haven't used this for quite a few years, but back when I was using it, I couldn't live without it. Embarcadero ER/Studio was a fantastic tool for database diagramming....
"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
February 10, 2016 at 5:02 am
Not to my knowledge. But, the data is stored there in a table, just write a different report using a good set of filters on the wait stats.
"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
February 10, 2016 at 4:58 am
You can use ALTER EVENT SESSION to add stuff in, but you will need to stop and restart the session.
"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
February 10, 2016 at 4:56 am
On most systems, most of the time, I recommend letting parallel execution occur. Instead of attempting to control it with maxdop, change the Cost Threshold for Parallelism. The default value...
"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
February 10, 2016 at 4:54 am
On a 2008 system, I'd use trace events. You can capture rpc_completed and sql_batch_completed calls which will show you what's being accessed. Unfortunately, filtering in trace events doesn't work 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
February 10, 2016 at 4:53 am
Nice queries, but you should include the caveats so that the original poster knows what they're getting.
The first two queries will show if a table or a stored procedure...
"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
February 10, 2016 at 4:50 am
Alerts? I'm not sure what you mean there.
Do you mean attempts at connections or failures at connections?
If so, the best tool you have for that in SQL Server 2014 is...
"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
February 10, 2016 at 4:43 am
Just remember that you'll have to poke holes through the firewall on both sides to allow communication through whatever port you have SQL Server running on (1433 by default).
"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
February 10, 2016 at 4:39 am
Alexander Suprun (2/9/2016)
jCoke (2/8/2016)
Yes, i am somewhat familiar with profiler, just dont know what to trace?
Just use default template and put filters on duration and database name, and save result...
"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
February 9, 2016 at 5:12 pm
Sean,
Here's hoping it all works out great.
"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
February 9, 2016 at 10:37 am
SQL!$@w$0ME (2/8/2016)
Grant Fritchey (2/8/2016)
What did you need the filegroup for?
Thanks Grant!
The db has been designed/created to use a user defined file group as default for data and a separate index...
"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
February 8, 2016 at 10:43 am
I haven't done this myself, but if I were going to do it, I'd use extended events. The trick is going to be filtering by a particular user. If 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
February 8, 2016 at 10:31 am
Nope. No file group support in Azure SQL Database. Azure SQL Database is a Platform as a Service (PaaS) offering for SQL Server databases. No options that require access 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
February 8, 2016 at 8:54 am
If you are trying to identify the longest running process, on a 2014 system, I wouldn't use Profiler (I wouldn't ever use Profiler to capture data, just consume already captured...
"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
February 8, 2016 at 8:47 am
Viewing 15 posts - 5,131 through 5,145 (of 22,219 total)