Monday, May 6, 2013

[SQL Server 2008 issues] Speed issue with SQL Server 2008 compared to SQL 2000

[SQL Server 2008 issues] Speed issue with SQL Server 2008 compared to SQL 2000

Speed issue with SQL Server 2008 compared to SQL 2000

Posted: 04 May 2013 07:47 PM PDT

We have built a new virtual server with Hyper-V and 64bit windows 2008R2 with 3 processors and 12 GB of ram allocated to the machine. The machine is a dedicated SQL server machine. I have set the max server memory to 10000MB, Use AWE memory is enabled with 255 maximum worker processors.Initally we had installed a database which is only 3GB in size so pretty small. The database is an uggrade from SQL 2000 to 2008. The problem we are having is that on the new server all the queries are running so much slower to the point that the machine is unusable. An example of this is a simple query that we have (select name from andotype where AndoTypeID = 2) ran in a loop 200 times takes over 8 seconds to execute, the same query on the SQL Server 2000 database on Windows Server 2003 runs in less than one second. Currently the new database has only one table, with the one row and just a primary key on the AndoTypeID field and it still runs over 8 seconds.I am not a SQL expert so I really need some help/advice on the right settings to get this to work.

best practices - development help

Posted: 05 May 2013 05:45 PM PDT

hi,im not sure this is the right forum to put this in, but i am working on redesigning our company database, and i was looking for best practices for the following:i have a table with different products. Now, i have x number of applications that uses these products, but depending on the application, they wont see all the products. So my first thought was to have one table called Products, then a second table that would be a ProductsExceptions, which would include the product id from products, and the application name where the product would not be applicable to. But im hesitant this is even an acceptable solution, so what would be the best way in a scenario like this?

Deadlock Issue

Posted: 05 May 2013 06:38 PM PDT

We are running SQL Server 2008R2 Ent and we are experiencing a high incident rate of Deadlocks . We started by adding some of the missing indexes . This practice did help to resolve some of the deadlocks. However we get a Clustered Index Update of 86% of the processing time during One particular Transaction . I had a look at the update statement and there is not much we can dot to optimize it as it is a simple update statement : " Update Table1 set column1 = Getdate() , column2 = 'Name1' where column 3 = 99999. This transaction causes the deadlock . Any ideas to resolve this issue ?

How could i find the client?

Posted: 02 May 2013 02:01 AM PDT

I have a consolidated SQL Server Machine, and none of application are running on this. But I have an error like below:[i][b]The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor.[/b][/i]How can i find the client driver? With Which events of Server Side Trace or Profiler trace?

Sorting Records Going Into New Table.

Posted: 05 May 2013 11:31 AM PDT

I am having problems ordering records to go into another table. The following is my code:[code]USEEURUSDGOSELECT *INTO NEWTABLEFROM OLDTABLEORDER BY RECORD[/code]After processing into another table I still have a wrong starting record and gaps in the continuous records. When I process a SELECT TOP 1000 query I am expecting to see the first record proceeding through the 1000th. record. Instead I am seeing record 8625 forward. How do I create a query to create a new table with the proper sequential ordering?

What happens if SSMS is force-closed by an RDP logoff while adding a column?

Posted: 05 May 2013 03:30 AM PDT

So I was tasked with adding an Identity column to a very large table this weekend. Yesterday it failed because the Transaction Log ran out of room (DB is in simple recovery.) So I re-set things up today, gave the TLog an extra file on another disk to try to prevent the out-of-log-space error, and fired off the alter table command.And went to get breakfast.And had the GPO enforced RDP log off kick in while I was gone.Forcing SSMS to close (I was RDPed into the server.)It looks like my alter table might still be running (based on sys.dm_exec_requests and grabbing the text from sys.dm_exec_sql_text) but is there any way to be sure? Exec_Requests currently shows the process as suspended with a wait_type of pageiolatch_ex, so I'm presuming it's waiting on the disk system before continuing.Any help?Jason

Post Transaction Log Full

Posted: 05 May 2013 04:15 AM PDT

I had a development database set to 'simple' recovery model which ran into a full transaction log error while executing a 'delete' query. I was able to resolve the issue by increasing the size of the X-action log, running a manual checkpoint. I then re-ran the query and it completed successfully.My question is about the last step - I re-ran the query. I did that because I understood that when the transaction log became full, not all the rows I intended to delete were actually deleted, and had to re-run to actually complete the deletion. Is this correct, or was this unnecessary ?

SQL Server 2008R2 'Web Edition' License Query

Posted: 05 Sep 2012 02:43 AM PDT

Hi AllI have what seemingly is a pretty basic query however dont seem to beable to get a definative answer (the licencing company we have seem to think Web Edition doesn't exist)I am currently working on a solution for a small company so costs are watched quite closely.We have what is essentially a reporting and configuration type web front end open to our clents sitting in the cloud on a SQL Database. This database is going to be fed partly by data from remote databases (SQL Express/via entity framework) sitting on client sites (its a monitoring set up).What I cant figure out is can I use Web Edition for this? It's not doing anything particularly fancy, just storing data for the webpage.Obviously this has large cost implications, whether we can use Web Edition, or have to get a CPU/Core License with Standard Edition.Unfortunatly cant use express on the cloud due to db sizeAny pointers would be helpfulThanks in AdvanceJack
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog