Tag Info

Hot answers tagged

3

Open SQL Server Configuration Manager In the SQL Server Services pane, locate the instance that has the problem Right-click that instance and select Properties On the Startup Parameters tab, type -f, click Add, then click Apply Right-click that instance and select Start (or Restart) This will start the instance in minimal configuration mode (single user, ...


2

In your question, there is not enough information to see where the problem is from technical point of view; however, I can see that there is a problem in communication between you as developer and the DBA. This is not abnormal though as DBAs and devs do not always 'speak the same language'. Let's go the some points in your question: You should rely on the ...


2

Based on your comment about the "unwieldy" SP I'd almost guarantee that is at least part of your problem. Try running the following query replacing DBName and SPName as appropriate. USE DBName GO SELECT SUBSTRING(text, statement_start_offset/2, CASE WHEN statement_end_offset = -1 THEN 999999 ELSE ...


1

Starting with the highest and moving down: SOS_SCHEDULER_YIELD This wait type is usually caused when you have queries performing huge scans. I'd suggest checking to make sure you have the proper indexes in place and you don't have any out-of-date statistics resulting in an inefficient query plan. OLEDB OLEDB waits indicate that your query has to reach ...


1

Search for mysql-related packages that are now installed: rpm -qa | grep -i mysql Delete any packages like mysql, mysql-server, mysql-client, mysql-shared, mysql-shared-compat, mysql-libs. yum remove mysql-server You do not need to remove mysql library bindings like python-mysqldb, php-mysql, etc., unless they had a dependency with some of the previous ...


1

They just released new server & driver packages (7/25/2014). I had the same issue with the old drivers but with the 7/25 release it is gone.



Only top voted, non community-wiki answers of a minimum length are eligible