Browse by Tags

CSS SQL Server Engineers

This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services
  • Blog Post: Assigning SQL Server, SQL Agent to a Processor Group (OOM, Hang, Performance Counters Always Zero for Buffer Pool, …)

    Suresh brought to my attention that we have been getting questions as to why SQL Server starts on group 1 and then group 2 and it is not predictable?  Then Tejas brought up another issues and since I worked on this way back before we released SQL 2008 R2 I went back to my notes to pull up some details...
  • Blog Post: How far can you push Windows?….

    As a member of technical support, it does seem I see users pushing our software to the limit more than most. But how does Windows really behave when pushed to the limit on resources? Well an excellent series of blog posts is available for you to find out. Start with this link by Mark Russinovich: http...
  • Blog Post: SQL Server and the Bad CPU

    From time to time I encounter an issue where the physical CPU is the source of the problem.   I hope you never encounter such and issue but I wanted to provide an example to help those that will. Customer started getting frequent dumps from the SQL Server process.   Looking at the...
  • Blog Post: Sparse File Errors: 1450 or 665 due to file fragmentation: Fixes and Workarounds

    You might be familiar with the sparse file problem that Bob Dorr has blogged about in the past. http://blogs.msdn.com/psssql/archive/2008/07/10/sql-server-reports-operating-system-error-1450-or-1452-or-665-retries.aspx . We wanted to update you with the work we have been involved in the past few months...
  • Blog Post: SQL Server I/O Bottleneck, I don't have one, YES YOU DO!

    The mistake I see people make is when looking at the SQL Server PAGE I/O waits and stalled I/O warnings is when comparing it to the Avg. Disk Seconds/Transfer.    Everyone seems to forget that average means average and they look at the value and say I don't see any I/O taking longer than...
  • Blog Post: SQL Server, Windows Server 2008, and the Windows Firewall

    Sounds like a movie title. No, it is actually a topic you need to know about if you plan to install SQL Server 2005 or SQL Server 2008 on Windows Server 2008. Instead of me trying to explain the details I would rather you learn from the experts on this topic. A very good blog post has been created by...
Page 1 of 1 (6 items)