Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Sp_monitor getting a 8115 msg

  I'm running sql 7 sp3 Is there a fix for this? last_run current_run …

  zach_john

  3 replies

  4 years ago

  By: VoldemarG

• First Steps to "slow" database analysis

  I want to investigate a possible "slow" running database. This is just a report I received and may …

  stevec883

  6 replies

  4 years, 8 months ago

  By: Evgeny Garaev

• Why is this query slow?

  #pastetheplan https://www.brentozar.com/pastetheplan/?id=SJF21m0lU I'm trying to figure out what's …

  kfrancis25

  19 replies

  5 years, 2 months ago

  By: kfrancis25

• Why is this query slow?

  #pastetheplan https://www.brentozar.com/pastetheplan/?id=SJF21m0lU I'm trying to figure out what's …

  kfrancis25

  3 replies

  5 years, 2 months ago

  By: kfrancis25

• CMEMTHREAD wait type

  I'm seeing a number of these - is there a way to find out what object they are waiting on and shoul…

  colin.Leversuch-Roberts

  2 replies

  5 years, 12 months ago

  By: Gail Wanabee

• Optimize Store Procedure

  I have a single Win R2 2008/64Bit/7.50GB of RAM SQL Server 2012 running and am using a WebApp runni…

  djacobos

  3 replies

  9 years ago

  By: djacobos

• Is there any log file for stored procedure ?

  Good day. I would like to know if all procedures in DB are used or not respectively. Is there any l…

  running_man_2016

  2 replies

  9 years, 1 month ago

  By: running_man_2016

• Problem in sql joins complex query to execute on remote server

  Hello, I have one sql query which has many joins and quite complex . The same query working fine on…

  vidhyasyd

  1 replies

  9 years, 2 months ago

  By: Sudhakar G

• Copy data and structure of database

  Hello, Is anyone know any tools that you can copy one server to another. We have 3 servers: Product…

  Krasavita

  6 replies

  9 years, 3 months ago

  By: BrainDonor

• Performance on server and pc

  Hello. I have a database and a table in this database has 1000000 rows. I have this database to my …

  athanasios.pan

  4 replies

  9 years, 4 months ago

  By: athanasios.pan

• Unique Index Causing Slow Read Performance

  Hi All This one's for the gurus out there. I am a pretty darn experienced SQL developer. This prob…

  ben.mcintyre

  29 replies

  9 years, 5 months ago

  By: ben.mcintyre

• Stored procedure slower then query

  This is an odd one I just ran into today.  I rebuilt an older query that aggregated together a…

  Kevin Brown-242904

  4 replies

  9 years, 5 months ago

  By: summer12in

• Spid is blocking itself?

  I haven't seen this before, and I can't seem to find what to search on to find an answer. What cond…

  Ariadne

  6 replies

  9 years, 6 months ago

  By: coolchaitu

• how to remove single query plan from cache - SQL 2000

  Hi, Still have a number of servers running 2000 and have one particular poorly performing stored pr…

  DuncEduardo

  2 replies

  9 years, 7 months ago

  By: DuncEduardo

• SQL Profiler Reads vs Set Statistics IO logical reads

  I created a table with a single varchar(10) column and ran a select statement against it. In Profi…

  Steve-443559

  5 replies

  9 years, 9 months ago

  By: MyDoggieJessie