Search Results | SQL Server Performance Forums

Percentage of Log space used

Thread by: dmaddhali, Mar 6, 2006, 12 replies, in forum: General DBA Questions

Hello All, I am trying to get the log space used by all the databases in sql server 2000/2005. I used "DBCC...

login failure trace not working in sql server 2000

Thread by: dmaddhali, Mar 1, 2006, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hello All, I am trying to monitor login failures in SQL Server 2000 and YUKON. I could successfull implement a trace to monitor login...

get substring in SQL Server 2005

Thread by: dmaddhali, Feb 20, 2006, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hello all, I need to get all the strings in between ''(sdf,adf,satish,rajesh,satish)from a table containing the below mentioned strings. I...

getting traceid parameter output using ADO

Thread by: dmaddhali, Feb 7, 2006, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi,<br /> I am in a process of creating a trace event class using ADO . These are the statements to create a trace event.<br /><br />...

setting up database mirroring

Thread by: dmaddhali, Feb 3, 2006, 9 replies, in forum: SQL Server 2005 Database Mirroring

Environment<img src='/community/emoticons/emotion-7.gif' alt=':S' />QL Server 2005 Enterprise in Win2k3 Enterprise on 32(x86) bit machine<br /><br...

need more info. in audit user error mess. trc file

Thread by: dmaddhali, Feb 3, 2006, 2 replies, in forum: SQL Server 2005 General Developer Questions

HelloAll, I am trying to create a trace for user error messages using audit user error messages event class.I could create .trc file. But...

index tuning stored procedures

Thread by: dmaddhali, Dec 20, 2005, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hello All I have a small query . Can we use any stored procedures / queries which can do the task of Index tuning wizard. What I mean is ; Is...

database mirroring perforcance counter

Thread by: dmaddhali, Dec 12, 2005, 2 replies, in forum: SQL Server 2005 Database Mirroring

I would like to monitor all the performance counter intormation related to database mirroring.there are sys tables which has information related to...

import .trc files into a table

Thread by: dmaddhali, Dec 8, 2005, 3 replies, in forum: General Developer Questions

Hello All, I have a requirement to import .trc(trace file) into a table . Can any one please help me out regarding this....

Parse errors generated due to Sql Injection

Thread by: dmaddhali, Dec 7, 2005, 9 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I would like to know the table/log which is populated by the SQL SERVER when failed attemps to login a SQL SERVER using SQL INJECTION IS...

sql server 2005 In-active indexes

Thread by: dmaddhali, Dec 5, 2005, 4 replies, in forum: SQL Server 2005 General DBA Questions

I am a developer working on sql server 2005 and I would like to know how to know about unused index. I have got some topics which ask us to used...

Trace event not logging information

Thread by: dmaddhali, Dec 2, 2005, 3 replies, in forum: T-SQL Performance Tuning for Developers

I created an Trace Event and set the event to get SQL::batchcompleted related log. Then I changed the status of event to start mode. I have used...

Monitoring DDL Statements(urgent requirement)

Thread by: dmaddhali, Nov 30, 2005, 6 replies, in forum: General Developer Questions

I would like to monitor all the DDL Statements which where executed when our product is not in maintanance mode. Please help me finding a way to know...

Monitoring DDL Statements(urgent requirement)

Thread by: dmaddhali, Nov 30, 2005, 9 replies, in forum: SQL Server Log Shipping

I would like to monitor all the DDL Statements which are executed .so that administrator can track all the illegal modifications done to the...