SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Transaction Log backu job sometimes fails with erooror: There is insufficient system memory in resource pool 'internal' to run this query.

  Hi We run SQL Server 20008R on Windows Server 2008R on HyperVWindows Machine is dedicated to run S…

  Svetlana Mikhalevskaya

  6 replies

  7 years, 5 months ago

  By: Sue_H

• can't install SQL SERVER 2008 SP3/SP4 on WINDOWS server 2016

  Good day Everyone, Does anyone here know the reason & how to install SQL SERVER SP3 on windows …

  maryrosepinon

  3 replies

  7 years, 7 months ago

  By: Jeff Moden

• Execution Plan turned "Bad"

  DB version: Microsoft SQL Server 2008 (SP1) - 10.0.2573.0 (X64) RCSI enabled Hi, last week one of o…

  adam_mail78

  4 replies

  7 years, 8 months ago

  By: adam_mail78

• Question w.r.t. amount columm

  Hello all, I am working on a SQL query will lots of joins and it is currently taking around a min t…

  sqlenthu 89358

  4 replies

  7 years, 8 months ago

  By: Steve Jones - SSC Editor

• Slow running stored procedure

  I am using SQL server R2.I have stored procedure which takes too much time to execute.I have posted…

  harshada_joshi

  3 replies

  7 years, 8 months ago

  By: ChrisM@Work

• SQL Server memory consumption is more

  OBJECTSTORE_LOCK_MANGER is consuming more memory.  Any idea how to fix this? I have attached i…

  vigneshbeece

  1 replies

  7 years, 8 months ago

  By: Ant-Green

• Why SQL Server is not using non-clustered index

  In SQL server 2008R2, Table having Non-clustered index and table contains 2 crore records, while ex…

  vigneshbeece

  4 replies

  7 years, 8 months ago

  By: Arsh

• why query optimizer is using Non-clustered index for count(*) operation

  why query optimizer is using Non-clustered index scan for "select  count(*)" operation and Clu…

  vigneshbeece

  2 replies

  7 years, 8 months ago

  By: BrainDonor

• Head blocker - Sleeping process with select command on empty table

  Hi,I have problem with troubleshoot blocking issue on SQL 2008 (10.0.5500), witch happens 5 to 10 t…

  marcin.dygutowicz 80747

  4 replies

  7 years, 8 months ago

  By: Gail Shaw

• How to check I/O Bottle necks

  I have attached perfmon report(SQL server to check disk IO) here for Average disk Sec/Read  &a…

  vigneshbeece

  3 replies

  7 years, 9 months ago

  By: Sue_H

• CPU spike when executing a query in SQL

  Hi, Our production environment recently have been witnessing spike in CPU utilization of more than …

  saum70

  7 replies

  7 years, 9 months ago

  By: Jeff Moden

• Troubleshooting non-working Plan Guide in SQL Server 2008 R2

  I have problems with a Plan Guide I have created in Microsoft SQL Server 2008 R2. The Plan guide is…

  Johan.Jansson

  1 replies

  7 years, 9 months ago

  By: Andrew G

• Query similar to wireshark

  Hi,We intend to write a query that will act like wireshark i.e. note down which process or program …

  saum70

  4 replies

  7 years, 10 months ago

  By: Jeff Moden

• Error: 18056, Severity: 20, State: 46.

  Hi Everyone, i am getting the following error message in sql server error log. Error: 18056, Severi…

  aprathour.89

  4 replies

  7 years, 11 months ago

  By: SQL ADMIN 79

• script to run dbcc indexdefrag for all databases in a server.

  Hi all,I'm trying to create a script to run dbcc indexdefrag not only for one database, but for all…

  mig28mx

  4 replies

  7 years, 11 months ago

  By: Sue_H