Search Results | SQL Server Performance Forums

ODS - Operation Data Source with small data comapring to Production to gain performance

Thread by: sachinonnet, Dec 27, 2012, 2 replies, in forum: ALL SQL SERVER QUESTIONS

Hi, we are in the process of building ODS - Operational Data source, ODS will contain only current 3yrs data, whereas Production server contain 10yrs...

How to Optimize SQL server performance with SAN

Thread by: sachinonnet, Oct 8, 2012, 2 replies, in forum: ALL SQL SERVER QUESTIONS

Hi, We are running SQL Server 2008 R2 64Bit , enterprise with SP1, for Storage we are using SAN. We are facing performance issue with IO below is...

How to Optimize SQL server performance with SAN

Thread by: sachinonnet, Oct 3, 2012, 1 replies, in forum: SQL Server 2008 Performance Tuning for DBAs

Hi, We are running SQL Server 2008 R2 64Bit , enterprise with SP1, for Storage we are using SAN. We are facing performance issue with IO below is...

SQL Server Auditing or monitoring DBA activitys

Thread by: sachinonnet, Jul 23, 2012, 2 replies, in forum: ALL SQL SERVER QUESTIONS

Hi, we want to implement solution to track DBA activity on SQL server 2008R2, activity's like: 1. Accessing DATA (SELECT/INSERT/UPDATE/DELETE) 2....

SQL Server Multiple Instances

Thread by: sachinonnet, May 8, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions

Is there any limit on SQL server Multiple Instances? if we require to run 60+ Instances on single machine what will be the minimum hardware...

GROUP_CONCAT OF MySQL

Thread by: sachinonnet, Apr 17, 2007, 3 replies, in forum: SQL Server 2005 General Developer Questions

Hello, I am Migrating one database of Mysql to SQL server 2005, I am facing problem with Views where in Mysql they have GROUP_Concat (aggregate...

SQL 2005 Backup Failed:(-1073548784)

Thread by: sachinonnet, Nov 15, 2006, 2 replies, in forum: SQL Server 2005 General DBA Questions

hello,<br /><br />I am using sql 2005 on widnows 2003 i configured on maintenency job for taking backup for user databases. out of 7 it backup 4 and...

Application Event

Thread by: sachinonnet, Nov 10, 2005, 4 replies, in forum: General DBA Questions

Hello, i am getting lot many information Event's in Application Log. i am using windows 2000 with SQL Enterprise 2000 SP4. can i stop there event's...

Event ID: 17055 Sorce : MSSQLSERVER

Thread by: sachinonnet, Aug 18, 2005, 2 replies, in forum: Performance Tuning for DBAs

hi, i am using windows 2000 SP4 with MS-SQL 2000 SP4 (130 databases). i am continusly getting below event's in eventlog. i want's know the mening of...

Memory Cache / Buffer problem

Thread by: sachinonnet, Feb 1, 2005, 9 replies, in forum: Performance Tuning for DBAs

am running SQL 2000 Enterprise edition V. Microsoft SQL Server 2000 - 8.00.760 (Intel X86) i am getting below errors... when i am fetching 200...