SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• 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

  6 years, 10 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

  6 years, 11 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

  6 years, 11 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

  6 years, 12 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 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 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 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 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 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 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 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, 1 month 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, 2 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, 2 months ago

  By: Sue_H

• Implicit converts for inserts

  Hi do implicit converts in insert statements matter? I talking about converting between char and va…

  alex.palmer

  1 replies

  7 years, 3 months ago

  By: Gail Shaw