Forum Replies Created
Viewing 15 posts - 331 through 345 (of 22,219 total)
-
Reply To: Logging SQLExceptions
Oh, and I missed the formatting thing. Yeah, it does it. Just double click on the batch_text or whatever field and it will open a window like this one:
"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 -
Reply To: Logging SQLExceptions
Jeff Moden wrote:Grant Fritchey wrote:Bedeencion40 wrote:Yeah, you can set up SQL Trace or Extended Events to catch those errors. It's like a net for those SQLExceptions. But in the long run, asking...
"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 -
Reply To: Review of DB Activity
So, probably, most of your scripts for looking at queries and query behavior use DMVs. Which were released in 2005. That means, those scripts won't work. If you want 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 -
Reply To: Logging SQLExceptions
Bedeencion40 wrote:Yeah, you can set up SQL Trace or Extended Events to catch those errors. It's like a net for those SQLExceptions. But in the long run, asking devs 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 -
Reply To: Large number of Memory Ring buffers
Presumably, that means a lot of Extended Events sessions outputing to the ring_buffers. Probably not the best way to go. Output to file is generally better. But, it does depend...
"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 -
Reply To: Suggestion on HA DR solution for transactional replication published database
Just piling on. I think @Ant-Green has nailed it. Availability Groups are where Microsoft has been investing all it's time and money. So if you're going to be building an...
"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 -
Reply To: Suggestion on HA DR solution for transactional replication published database
Just piling on. I think @Ant-Green has nailed it. Availability Groups are where Microsoft has been investing all it's time and money. So if you're going to be building an...
"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 -
Reply To: SQL Server Windows NT - 64 bit" in Task Manager: CPU high
I'm confused. What is this in relation 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 -
Reply To: You Never Know
And very much still is.
"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 -
Reply To: Log shipping time_since_last_backup
Excellent! Thanks again. Glad you got it all figured out.
"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 -
Reply To: SQL2017 DBMirroring Query store not working on mirrored databases
Ah, sorry I misunderstood.
If they were switched to read only on you, it's likely something to do with size and the cleanup management. The size-based cleanup should be a backup...
"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 -
Reply To: Advanced SQL Query Optimization Assistance Needed
So, SQL Server is time-tested and extremely reliable. It simply does not randomly provide values based on whims or anything like that. It is ALWAYS down to the code, structures,...
"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 -
Reply To: SQL2017 DBMirroring Query store not working on mirrored databases
Mirrored databases can't be written to, right? If so, then I'm pretty sure Query Store won't work on a mirrored database. Same as AG. It doesn't work there either (except...
"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 -
Reply To: Log shipping time_since_last_backup
Cool! Can you detail a little more for the person who has the same question as you so that they can see the answer too?
"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 -
Reply To: SQL Scripts automatically invoked
Looks like a monitoring query. It's probably being run from a monitoring tool. I've no idea how to tell you when it will next be executed. I'd suggest you use...
"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 - 331 through 345 (of 22,219 total)