Search Results | SQL Server Performance Forums

An Application Tunning Tool on SQL Server?!

Thread by: ufobox, Dec 15, 2003, 9 replies, in forum: Third Party Tools

Does anybody use, An Application Tunning Tool on SQL Server?! Quest? Thanks

NETIQ DiagnosticManager

Thread by: ufobox, Dec 2, 2003, 7 replies, in forum: Third Party Tools

Does anybody purchase/use NETIQ DiagnosticManager? It seems nice. [}<img src='/community/emoticons/emotion-1.gif' alt=':)' />]

report/output about SQL 2000's Lock Owner Blocks

Thread by: ufobox, Feb 27, 2003, 1 replies, in forum: Performance Tuning for DBAs

Does anybody has a script/stored-procedure to general a report/output about SQL 2000's Lock Owner Blocks in order to collect the real-time statics?...

lock-flag in VB5???

Thread by: ufobox, Feb 27, 2003, 3 replies, in forum: T-SQL Performance Tuning for Developers

Does anybody know: How can I get SQL error message/lock-flag? For example, If a user try to update one table, if the table is locked by others....

Difference: SQL 2000/SP3(65) & SQL7/SP3(65)

Thread by: ufobox, Feb 11, 2003, 1 replies, in forum: General DBA Questions

There're a lot of difference between SQL 2000/SP3(65) and SQL7/SP3(65), including: different system table name, different system table's column name,...

run a store procedure after SQL server reboot???

Thread by: ufobox, Jan 3, 2003, 2 replies, in forum: General DBA Questions

I want to run a store procedure after SQL server reboot. Currently, I create a sql job call it and set job-schedule as 'Start automatically when SQL...

How much RAM is enough per client?

Thread by: ufobox, Dec 9, 2002, 20 replies, in forum: Performance Tuning for Hardware Configurations

Could anybody tell, How much RAM is enough per client? Thanks.

Does the Pinned Tables effect server's performance

Thread by: ufobox, Dec 7, 2002, 9 replies, in forum: T-SQL Performance Tuning for Developers

Can anybody tell, Does the Pinned Tables effect SQL server's performance? Thanks, HJ

SQL Replication

Thread by: ufobox, Dec 5, 2002, 5 replies, in forum: Please Tell Us What You Think

Would you please open a forum for SQL server replication later?

Terminal client on SQL server

Thread by: ufobox, Dec 5, 2002, 9 replies, in forum: Performance Tuning for Hardware Configurations

Does anybody know how to improve performance if I get 100 Terminal clients on SQL server? Thanks, HJ

Disscuss & Vote about hard disk

Thread by: ufobox, Dec 5, 2002, 8 replies, in forum: Performance Tuning for Hardware Configurations

For hard disk's capacity, If I have 10G SQL 7 database (2G memory), I would have 2-3 times free hard to support it. MDF is 10G; LDF is 2-3G; temp DB...

how to trace a SP

Thread by: ufobox, Dec 5, 2002, 3 replies, in forum: General DBA Questions

Does anybody know how to trace a SP? Except SQL-profiler & DBCC inputbuffer(). Thanks. HJ

Upgrade hardware without replacing old server!!!

Thread by: ufobox, Dec 5, 2002, 5 replies, in forum: Performance Tuning for DBAs

Does anybody hear about some hardware solution about upgrading hardware unlimited & freely without replacing old server. for example,<br...