Friday, October 4, 2013

[SQL Server 2008 issues] Page Life Expectancy dropping in value

[SQL Server 2008 issues] Page Life Expectancy dropping in value

Page Life Expectancy dropping in value

Posted: 03 Oct 2013 02:50 AM PDT

I have an issue whereby every now and again throughout the day the PLE value plummits from something like 14hrs to 0.1hr. It is at this point I get complaints of the app running slowly. CPU looks fine. Also the buffer cache hit ratio is within normal operational levels. Is this indicative of some poorly written code somewhere ? What can I do to further investigate this to help increase performance ?

Replication from sql server to oracle

Posted: 03 Oct 2013 06:36 PM PDT

Hi I am not sure how to start this. I was given a task to start replication from Sql server 2008 R2 to Oracle 11gI have tried google, I couldn't understand clearly where to start.What permissions required on oracle and what is to be done at Oracle end to support replication.The same from sql server side?Can anyone give details step by step?thanks in advance.

split a comma delimited string into columns

Posted: 03 Oct 2013 04:21 PM PDT

DECLARE @p NVARCHAR(MAX)SELECT @P = 'MONDAY,SUN,FUN,D'DECLARE @STRSQL NVARCHAR(MAX)SET @SQL = 'SELECT ''' + REPLACE(@P,',',''',''') + ''''EXEC( SQL)Above Code is splitting the comma delimited string into four columns but how to give columns names with in this code.?? I was trying this with creating new dynamic table with four column but i am not sure that if it really works.

ssis question

Posted: 03 Oct 2013 06:27 AM PDT

i have a proc that is getting called and returns a filename that loads into cache in ssis. How do i then make a connection to that file? I dont see anywhere in the connection manager a way to full the filename from the result set

Using missing index DMVs to look for (potentially) helpful indexes...

Posted: 03 Oct 2013 02:02 AM PDT

So I had come across a query (don't recall where) which uses four missing index DMVs to give an idea as to where the SQL engine thinks an index might help. Now, I'm not blindly following it's suggestions (as of now I've used its recommendations to add ONE index to replace an existing index,) but I'd like to get an idea of what others think.The columns I'm paying the most attention to when looking for possible improvements are:sys.dm_db_missing_index_group_stats User_seeks User_scans avg_total_user_costSo far, my feeling is, if the seeks and scans are low, then don't add the index regardless of what the user_cost is.Does anyone have any suggested guidelines for those numbers?I'm using 100 or higher for seeks and scans combined, and 250 for user_cost or higher.Obviously, if I'm going to implement one of these index suggestions, I'll need to weigh the impact of maintaining the index as well.Last, the code I'm using (and if anyone recognizes it, let me know whose it is so I can credit them:)[code="sql"]SELECT db_name(mid.database_id) as [DBName], statement AS [database.scheme.table], column_id, column_name, column_usage, mid.included_columns, migs.user_seeks, migs.user_scans, migs.last_user_seek, migs.avg_total_user_cost, migs.avg_user_impact, (migs.user_seeks + migs.user_scans) * migs.avg_total_user_cost * (migs.avg_user_impact * 0.01) as [Index Advantage]FROM sys.dm_db_missing_index_details AS mid CROSS APPLY sys.dm_db_missing_index_columns (mid.index_handle) INNER JOIN sys.dm_db_missing_index_groups AS mig ON mig.index_handle = mid.index_handle INNER JOIN sys.dm_db_missing_index_group_stats AS migs ON mig.index_group_handle=migs.group_handlewhere db_name(mid.database_id) not in ('msdb','master','model','tempdb')and migs.avg_total_user_cost >= 250and migs.user_seeks + migs.user_scans >= 100ORDER BY mid.database_id, migs.avg_total_user_cost[/code]

Unable to start SQL Server agent after server restart( Sql Server 2012)

Posted: 02 Oct 2013 09:34 PM PDT

Hi I am not bale to start Server agent after server restart( Sql Server 2012) .It is giving me the following error ."The service did not respond to the start or control request in a timely fashion .[0x8007041d]"Can anyone help pls.Gita

Windows/SSIS - File Transfer Protocol question

Posted: 03 Oct 2013 02:17 AM PDT

Can we download file from an ftp server without knowing the file extension. Directory would have multiple file formats. I dont want to use get *.txt or the like. I know the file name only, but not the extension. Is it doable?

Cannot open New SSIS Project in SQL Server 2008 R2

Posted: 02 Nov 2012 12:03 PM PDT

I installed SQL Server 2008 R2 and Visual Studio 2008. However, after several installations and un-installations. I could no longer use the SSIS to create New Projects. I cleaned out the registry with a Registry cleaner from Wise. I deleted the SQL Server and Visual Studio folders as well.When I create a New SSIS Project, I immediately get an error as follows:"Microsoft Visual Studio""An error prevented the view from loading.""Additional information:""Specified Module cannot be Found. (Exception from HRESULT: 0x8007007E)""(System.Windows.Forms)"How do I resolve this problem? What this means is that I cannot create any new SSIS Projects.Cecil

SQL Transaction Log

Posted: 03 Oct 2013 12:37 AM PDT

Hi everyone,My transaction log file is bigger and bigger every day, can I truncate the file? If it can, does it affect any thing such as performance?Best regards;

SQL Transactional Replication

Posted: 03 Oct 2013 12:35 AM PDT

Hi,Can someone guide me how to back up transactional replication? The problem is when my live db got the problem, I need to restore back, but require me to reconfigure transactional replication and initialize schema again. Thanks and Best Regards;

SQL 2008 SSIS package problem with data export

Posted: 03 Oct 2013 12:22 AM PDT

I have an SSIS package I developed using the Import/Export Wizard as a base. It truncates certain tables in our Dev environment then populates them with Production data. While the package works fine on my desktop (and does not fail when run via a job on the Production server), running it via the job doesn't always fully populate the tables down in Dev.For instance, this is what I got from the log file:[quote]DataFlow: 2013-10-02 09:31:05.10 Source: Load Destinations 0-4 Component "Destination 4 - Staging_X1" (1258) will receive 3744 rows on input "Destination Input" (1271)End DataFlow[/quote]Staging_X1 in Production has 16802593 rows worth of data. Dev ends up with less than a third of that but more than the message above states (so I'm thinking the log entry is just telling me the rows per batch).Has anyone seen this behavior before? These are OLE DB Source and Destination connections, nothing between them. I'm using Fast Load with Keep identity, Table lock, and Check constraints. I don't have a Rows per batch set, and the Maximum insert commit size is set to 2147483647. AccessMode is OpenRowset Using FastLoad.

Memory uitilization

Posted: 02 Oct 2013 09:06 PM PDT

Hi I asked bu one of my clients to schedule daily moinotring reports and provide cpu and memory uitilization of sql server.Now please help me how to proceed with it specially memory partThanks and RegardsAnoop pandey
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog