[MS SQL Server] Memory Issues on production sql server |
- Memory Issues on production sql server
- Need a blocking script with specific details
- Linked Server - Works Except With Insert Statement
- Can we Create sql server instance through script?
- Cannot backup - Old killed backup still running
- Cache Memory
| Memory Issues on production sql server Posted: 10 Jul 2013 07:21 AM PDT Please help me in this situation.Total memory on box : 10 GBSingle node, non clustered production boxMin memory is set to 0Max Memory is set to 8 GBFrom last month the box Memory is constantly at 95%CPU usage is very lowhere is the screen shot from the task manager[img]http://img838.imageshack.us/img838/1104/p77j.png[/img]How to find Is SQL server using the complete 8GB ?Management is asking to reduce the SQL server memory setting to 7GBIs this fine to decrease the memory limit. Please advice. |
| Need a blocking script with specific details Posted: 23 Jul 2013 02:23 AM PDT Hello All, I am looking for a script that will give me these details. 1) spid2) Total number of spids it is blocking directly or indirectly. 3) blocking Query4) Login name who ran the Query. 5) how long the query has been running for. I am able to get all the info except "total numberof SPIDs it is blocking directly or indirectly"Can somebody please help me with this, that will be very helpful. thanks in advance. regardsVB |
| Linked Server - Works Except With Insert Statement Posted: 22 Jul 2013 06:11 AM PDT I am trying to get Job information from ServerB, and populate a Table Variable on ServerA. From ServerA, I am running the following command with a Linked Server to ServerB.If I run this by itself from ServerA, I get the expected results in the query window. And if I insert into a table variable from the local server it works file[code="sql"]EXECUTE [LinkedServer_B].master.dbo.xp_sqlagent_enum_jobs 1,''[/code]But when I try the 2nd block of code inserting into the table variable from the linked server, I get an error.[code="sql"]DECLARE @currently_running_jobs TABLE ( job_id UNIQUEIDENTIFIER NOT NULL ,last_run_date INT NOT NULL ,last_run_time INT NOT NULL ,next_run_date INT NOT NULL ,next_run_time INT NOT NULL ,next_run_schedule_id INT NOT NULL ,requested_to_run INT NOT NULL ,request_source INT NOT NULL ,request_source_id SYSNAME COLLATE database_default NULL ,running INT NOT NULL ,current_step INT NOT NULL ,current_retry_attempt INT NOT NULL ,job_state INT NOT NULL ) -- 0 = Not idle or suspended, 1 = Executing, 2 = Waiting For Thread, 3 = Between Retries, 4 = Idle, 5 = Suspended, [6 = WaitingForStepToFinish], 7 = PerformingCompletionActions --Capture Jobs currently workingINSERT INTO @currently_running_jobsEXECUTE [LinkedServer_B].master.dbo.xp_sqlagent_enum_jobs 1,''[/code]ERROR:[b]OLE DB provider "SQLNCLI10" for linked server "LinkedServer_B" returned message "The partner transaction manager has disabled its support for remote/network transactions.".Msg 7391, Level 16, State 2, Line 21The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "LinkedServer_B" was unable to begin a distributed transaction.[/b] |
| Can we Create sql server instance through script? Posted: 12 Jul 2013 04:19 PM PDT Hi, I am using SQL server 2008 standard edition. Is there a way to create a new server Instance by a script except the default instance.? Thanks. |
| Cannot backup - Old killed backup still running Posted: 24 Mar 2013 11:57 PM PDT Hi I have one DB that on a multi DB server that people cannot connect to. I'm not familar with the DB.I THINK the problem was that an reindex or backup was ongoing when the Server was restarted.If I try and backup the DB now I get this error:System.Data.SqlClient.SqlError: Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed. (Microsoft.SqlServer.Smo)I can find 2 processes which have been killed: KILLED/ROLLBACK status=SUSPENDED. Both have wait time (ms) of a couple of dayskill 85 with statusonlySPID 85: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.How can I remove these so I may get the DB back up and working. Would a SQL restart work..Thanks |
| Posted: 22 Jul 2013 04:05 PM PDT Hi,How to find out Total amount of dynamic memory (in megabytes) that theserver is using for the dynamic SQL cache. |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment