Friday, April 5, 2013

[MS SQL Server] disk i/o

[MS SQL Server] disk i/o

disk i/o

Posted: 04 Apr 2013 01:48 PM PDT

We have a SQL server with 25 GB RAM, it is used for data warehouse. When the user restores one of their big databases, it slows down the network, and sometimes caused Exchange server down. The data and log, and backup drive are all on the same SAN.What could be the problem? I guess it may be related with disk I/O, how should I start to troubleshooting?Thanks,

Insert into a table when new record

Posted: 05 Apr 2013 05:34 AM PDT

Hello,I would need help from a programming front...I guess this is probably done via trigger but not sure how to start.When [u]table1[/u] gets a new record added , only certain fields from table1 records would need to be inserted into [u]table2[/u]Many thx

SSIS - Database Transfer Wizard - @flags parameters is not valid

Posted: 04 Feb 2013 05:43 AM PST

I'm trying to use copy database wizard to make a copy of a SQL Server 2005 database (9.0.3042) on a SQL Server 2012 machine (11.0.2100). I'm using the "SQL Management Object method" so that the orginal database can remain online. When I get to the final step I recieve the following error:- Start SQL Server Agent Job (Error) Messages * Create failed for JobStep 'CDW_KC4DATABASE_KCCDB_0_Step'. (Copy Database Wizard)The @flags parameter is not valid for a job step of type 'SSIS'. (Microsoft SQL Server, Error: 14545)I can't seem to find anything on the internet regarding "@flags parameter is not valid". Of course the two links provided in the error log that go to microsoft's site are totally useless. The full error message follows:[i]Performing operation- Add log for package (Success)- Add task for transferring database objects (Success)- Create package (Success)- Start SQL Server Agent Job (Error) Messages * Create failed for JobStep 'CDW_KC4DATABASE_KCCDB_0_Step'. (Copy Database Wizard) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0038+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The @flags parameter is not valid for a job step of type 'SSIS'. (Microsoft SQL Server, Error: 14545) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.00.2100&EvtSrc=MSSQLServer&EvtID=14545&LinkId=20476 - Execute SQL Server Agent Job (Stopped)[/i]Anyone have any insight?Thanks!

Orphaned users

Posted: 04 Apr 2013 09:42 PM PDT

I've 2 sql server instances on my local system.I backed up a database from one instance and restored that database on the other instance.I copied over the logins from the 1st instance to the 2nd instance.Then I ran the following statement on the 2nd instance to check if there are any orphaned users but I got 0 results.sp_change_users_login @Action='Report'GOBut I still cannot login into the newly restored database with any of the sql server logins. Am i missing something?

steps for proper configure in AWE?

Posted: 04 Apr 2013 05:24 PM PDT

Hi,Server OS - Windwos 2008 Enterprise Edition 32 bitDatabase - SQL Server 2008 Standared Edition 32 bitMemory - 32GB.[u]As per current configuration setup as below[/u]1. AWE - enabled in SQL Instance side.. But OS level not enable and not adding /3GB or PAE switch in boot.ini file.2. LPIM - Not Enabled and not added SQL service account in LPIM at local policy.(In windows 2008 if facing error like memory swapping out in error log file then only need to enable at LPIM when configure AWE option)[u]Pl. confirm as below steps for proper configure in AWE.[/u]Step1:Set Max memory - 6144 MB at SQL instance file ( Total 32GB memory assign 6GB in SQL and remain other application & OS side, this server is not dedicated SQL) Step2:C:\> bcdedit /SET IncreaseuserVA /3GB 3078Step3:SQL Service account added into LPIM at local policy (is it require in SQL2K8 standard edition?)Step4:Restart the server for take effect AWE feature.rgdsananda

Growing Log Files

Posted: 04 Apr 2013 10:39 AM PDT

I am intermediate in database admin. Please give me your solution for this issue. Size of my db is growing about 5M every 2 weeks. Now its size is 118G. my db is in full recovery mode, and I do not have log backup.Is this a good solution?1- Perform a full backup2- execute checkpoint3-Perform full Backup4- Perform transactional log backup5- shrink log file type6- schedule transactional log backupAlso, can I do these processes during users are connected ?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog