Viewing 15 posts - 5,116 through 5,130 (of 22,211 total)
I'm pretty sure you have to manage that outside of the extended events session. It doesn't manage data files. It just collects them.
February 11, 2016 at 11:22 am
I prefer a server named Colossus, but I've always loved the classics.
February 11, 2016 at 5:46 am
Excellent. I wasn't aware of that.
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...
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...
February 10, 2016 at 8:28 am
Be prepared for a lot of friction. It's actually difficult to coordinate releases of this type.
February 10, 2016 at 7:42 am
PSB (2/10/2016)
How can I investigate that ? When I look at...
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...
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....
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.
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.
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...
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...
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...
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...
February 10, 2016 at 4:43 am
Viewing 15 posts - 5,116 through 5,130 (of 22,211 total)