troubleshooting Question

query optimization

Avatar of MD SHAMIM
MD SHAMIM asked on
Microsoft SQL Server 2008
6 Comments1 Solution114 ViewsLast Modified:
how could i improve below query performance .in test server it takes more than 2 minutes .In prod busy server( millions of rows ) it will take more time to execute .any good thoghts would help .

DECLARE @Date varchar(10) = '3/16/2017';
DECLARE @Client varchar(50) = 'logix';
SELECT count(*) AS 'SSN Checks'
FROM vwEvent
WHERE EventType = 'SigningPing'
AND EventDate = @Date
AND EventParam4 = @Client
AND EventParam2 like '%/NameSSN/%'

thanks all in advance
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros