We have an application that is running 24x7 on a Sql Server 2000 SP 1 database.
We wanted to analyze the activities on the live server by turning on the SQL Profiler tool on another server and pointing it to the live database.
There are considerable amount of transactions/queries that are run against the live server.
My question is, how does the SQL profiler affect the performance of a SQL server database and how does it affect the CPU usage of the server?
It is minimal..so long as you don't capture a ton of events. If you're doing the trace through profiler, run profiler on a separate pc that your sql server, just connect to the sql server. if you store
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb. Luckily, there is a free version SQL Express, but does …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed