Viewing 15 posts - 5,131 through 5,145 (of 22,224 total)
Excellent. I wasn't aware of 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 10:25 am
Muhanned Maayeh-445298 (2/10/2016)
Grant Fritchey (2/10/2016)
Muhanned Maayeh-445298 (2/10/2016)
Grant Fritchey (2/10/2016)
Be prepared for a lot of friction. It's actually difficult to coordinate releases of this type.
I certainly hope not but, I think...
"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 8:49 am
Muhanned Maayeh-445298 (2/10/2016)
Grant Fritchey (2/10/2016)
Be prepared for a lot of friction. It's actually difficult to coordinate releases of this type.
I certainly hope not but, I think these releases will have...
"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 8:28 am
Be prepared for a lot of friction. It's actually difficult to coordinate releases of this type.
"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 7:42 am
PSB (2/10/2016)
How can I investigate that ? When I look at...
"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 6:52 am
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
Viewing 15 posts - 5,131 through 5,145 (of 22,224 total)