[MS SQL Server] SQL 08R2 SP2 - did not update!! |
- SQL 08R2 SP2 - did not update!!
- Question about clustering
- \Microsoft SQL Server\100\COM directory filling up with .err files
- SQL Ring Buffers
| SQL 08R2 SP2 - did not update!! Posted: 14 Mar 2013 01:55 AM PDT Hello SQL peeps, I installed SQL 08R2 SP2 last week on about 20 servers however one did not update. (All where being updated from SQL 08R2 SP1)The install ran just fine, all 5 times, but it did not update the server on restart, shut down, power off and on. I did the normal @@version and it never updated. Has anyone else seen this, before I call MS?Many Thanks,:cool: |
| Posted: 13 Mar 2013 11:30 PM PDT Hello,I would like to ask for some insights about SQL Server Clustering. When you fail over an instance to another node, does the cache also gets reset?Thank you. |
| \Microsoft SQL Server\100\COM directory filling up with .err files Posted: 13 Mar 2013 09:12 PM PDT The C:\Program Files\Microsoft SQL Server\100\COM\ directory on some of my replication subscriber servers is filling with .err files over time - some are 0.5 GB.The files are named in the format [Publisher]-[Publication]-[Subscriber]-UniqueIdentifier.[b]err[/b]Is the location of these error files configuration i.e. can I get them off the C: drive so it doesn't fill up?Is there any cleanup job that goes with these?Any advice appreciated. Google only throws up issues where "temporary" files can't be written to this directory due to security, but these .err files are hanging around too long to be temporary. |
| Posted: 13 Mar 2013 07:24 PM PDT Hi AllWhen analyzing SQL's ring buffers using the below[code="sql"]SET QUOTED_IDENTIFIER ONSELECT EventTime, n.value('(Pool)[1]', 'int') AS [Pool], n.value('(Broker)[1]', 'varchar(40)') AS [Broker], n.value('(Notification)[1]', 'varchar(40)') AS [Notification], n.value('(MemoryRatio)[1]', 'int') AS [MemoryRatio], n.value('(NewTarget)[1]', 'int') AS [NewTarget], n.value('(Overall)[1]', 'int') AS [Overall], n.value('(Rate)[1]', 'int') AS [Rate], n.value('(CurrentlyPredicted)[1]', 'int') AS [CurrentlyPredicted], n.value('(CurrentlyAllocated)[1]', 'int') AS [CurrentlyAllocated]FROM ( SELECT DATEADD (ss, (-1 * ((cpu_ticks / CONVERT (float, ( cpu_ticks / ms_ticks ))) - [timestamp])/1000), GETDATE()) AS EventTime, CONVERT (xml, record) AS record FROM sys.dm_os_ring_buffers CROSS JOIN sys.dm_os_sys_info WHERE ring_buffer_type = 'RING_BUFFER_MEMORY_BROKER') AS tCROSS APPLY record.nodes('/Record/MemoryBroker') AS x(n)ORDER BY EventTime DESC;[/code]Which broker would indicate pressure in the data cache portion of the buffer pool?I think that the MEMORYBROKER_FOR_CACHE reports on the plan cache portion of the buffer pool, is this right?Thanks |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment